Senior Database Engineer

SUMMARY

Responsible for supporting the design, implementation, and administration of database needs for the company. Performs all duties in accordance with all company policies and procedures, and all federal, state and local laws, wherein the Company operates.

ESSENTIAL DUTIES AND RESPONSIBILITIES

•    Ensures database integrity, stability and system availability.

•    Performs database server installations, patches, and upgrades, including both standalone and high availability environments.

•    Implements database maintenance best practices including index rebuilds, distribution statistics, and database consistency checks.

•    Develops backups, recovery and recovery testing, and verification.

•    Performs database performance tuning activities such as analyzing SQL server query plans, index tuning, troubleshooting database blocking, and resolving deadlocks.

•    Monitors, maintains database systems and troubleshoots problems that may arise.

•    Maintains data integrity and security (manage roles and permissions of database users).

•    Uses tools like SQL Profiler for database tuning. Generates traces, executes plans, identifies performance issues, deadlocks/contention and resolves them.

•    Develops strategies and implements solutions for managing back-ups, restoration and replication.

•    Works with developers to create new applications that use databases or modifying existing applications to improve their performance or functionality.

•    Creates documentation to explain how to use databases effectively and efficiently.

•    Supports software developers with database operations including the development of complex SQL, tuning of DML and the creation of stored procedures.

•    Leads, mentors and cross trains other team members.

•    Participates and contributes input in high level project planning, providing database tasks and milestones for project plans. Supervises and delegates projects.

•    Participates in hardware capacity planning and configuration for database environments.

•    Architect for high availability and disaster recovery solutions for database environments.

•    Analyzes and resolves database-related issues in areas of performance, availability, and production operations as needed within established SLAs. 

•    Provides 24x7 standby support on a rotational basis.

•    Performs other duties as assigned.

QUALIFICATIONS

EDUCATION / EXPERIENCE

Bachelor’s degree in computer technology or equivalent combination of education and experience

Ten (10) or more years of experience in administering Microsoft SQL server

Eight (8) or more years of experience with Windows O/S

Extensive experience writing T-SQL and stored procedures and query tuning on high transaction systems

Extensive Experience in SQL Server Integration Services (SSIS), SQL Server Reporting Services

(SSRS) and SQL Server Analysis Services (SSAS)

Extensive Experience with SQL server profiler for monitoring and troubleshooting database activity and performance

Experienced in SQL Server Clustering and HA technologies including mirroring, log shipping, failover cluster and various replication technologies would be an advantage

High knowledge of modern data network, enterprise storage (SAN, NAS, etc.), server consolidation, server virtualization, directories, and disaster recovery technologies

Extensive knowledge of complex computing management systems including system administration, performance monitoring, problem management, change management, records management, and disaster prevention and recovery

Data warehousing, data modeling, and business intelligence knowledge a plus

MCDBA, CMDBA, or equivalent technical certification preferred

SKILLS

Strong verbal and written communication skills 

Strong organizational and documentation skills

Good planning, prioritization and time management skills

Excellent conceptual, analytical and problem-solving skills

Strong knowledge of database security best practices

Ability to work within a team and to foster teamwork

Proficient in Microsoft Office products

#LI-DD1