Database Engineer

Key Responsibilities:

Install and configure new Microsoft SQL Server instances, including AlwaysOn availability groups and failover clustering.
Highly skilled at database design, installations, conversions. Responsible for database backup and recovery procedures, access security, and database integrity, physical data storage design, and data storage management.
Participates in Database Management System selection and maintains database performance.
Engage in ongoing process improvement.
Experienced in Database Performance, Maintenance, and Development to perform the following:
Database management including backups, recovery, and maintenance.
Database management for export, import, and mass data loads.
Analyzes and generation of all tables and index statistics.
Monitoring and resolving data lock issues.
Check all statistics related to memory, locks, I/O, database response time, wait events, top sessions, and background processes.
On-Line Transaction Processing (OLTP) to capture, validate, and store large amounts of transactions.
Create indexes to achieve critical dataset response time for time-sensitive reports.
Install SQL Server service packs and updates.
Configure and manage SQL Security settings.
Make system design recommendations according to Microsoft SQL Server best practices.
Manage database backup & recovery & DR planning.
6+ years of experience of High Availability (HA) and Disaster Recovery (DR) options for SQL Server.
6+ years of experience with Performance Tuning and Optimization (PTO).
Create, modify, and optimize SQL Server Agent jobs and maintenance plans.
Proactively monitor SQL Server maintenance tasks, troubleshoot failed jobs, and resolve issues in a timely manner.
Troubleshoot application slowness and performance issues.
Responsible for T-SQL query tuning. Responsible for database migrations and server upgrades.
Develop documentation and training of routine database administration tasks and train server operations staff on these tasks.
Responsible for ETL of large data into SQL Server. Author and modify SQL Server Reporting Services reports.
Perform SQL Server integration with enterprise applications.
T-SQL Programming & Perform additional tasks as assigned.
MS SQL Server Certifications are a plus.

Essential Qualifications:

Bachelor's degree in Computer Science, Information Technology, or related field.
Proven experience in MS SQL Server database administration.
Strong analytical and problem-solving skills.
Excellent communication and collaboration skills.