Under the direction of a Senior DBA or IT Manager, contribute tho the growth of the organization by maintaining and implementing software based solutions as needed. Responsible for creating new or modifying existing database designs by interpreting standards established by the company. Provide technicial guidance and follow-up on system issues and ensure resolution. Use business knowledge to identify potential improvements in application.
Essential Functions and Responsibilities
Strong SQL Server development skills
Completes functional database tasks under the direction of a lead to create and/or modify new and existing stored procedures as well as script out data manipulation language (DML) queries for ad-hoc reporting.
Responsible for data delivery to numerous end users through direct access, web services, SSIS.
Familiar with database concepts of design and configuration.
Implements and maintains indexes, triggers and views for mission critical databases.
Tunes the database for performance gains with the assistance of the lead.
Works with limited supervision and relies on prior experience and judgement to fulfill assigned duties.
Managing and versioning the database projects using Visual Studio Team Edition
Collaborates with DBAs, data architect, software developers, system architects, and quality assurance to complete business initiatives in a timely manner. This is not limited to the internal department; must deal with other departments to meet business needs.
Maintains and improves on understanding of current Microsoft SQL Server and emerging Microsoft SQL Server technologies.
Practice in an information technology field
Proven Analytical and troubleshooting skills
Ability to set scope amd deliver quality results
Effectively balance and prioritize multiple projects concurrently
Strong communication skills both orally and in writing
2+ years exposure or experience to relational databases using MS SQL Server
Positive and professional attitude