What are the responsibilities and job description for the SR. SQL DBA position at AGM Tech Solutions?
AGM Tech Solutions, on behalf of our highly reputable Client, is proudly hiring top talent to join their innovative team.
Hybrid
Position Title : Sr. SQL DBA
Position Summary :
The SQL Production Database Administrator (DBA) will be responsible for the implementation, configuration, maintenance, and performance of critical SQL Server RDBMS systems, ensuring the availability and consistent performance of the RUN application. The successful candidate will be responsible for monitoring, maintaining and updating SQL Server Clusters within a 24x7 Production environment. They must also be able to diagnose database related application problems, perform root cause analysis and recommend corrective action in coordination with other Engineering DBAs and Application Developers. The candidate will also provide DBA support for other non- production environments as required.
KEY RESPONSIBILITIES : Optimize production system and identify bottlenecks, ensuring high levels of data availability. Liaise with Developers and Engineers and provide SQL Server database expertise when needed.
KEY DUTIES / TASKS : - Monitors business critical production SQL Server clusters during peak hours and respond to incidents to ensure high levels of availability - Performs SQL Server 2017 cluster and standalone installation and configuration in accordance with documented standards - Collects detailed SQL Servers performance metrics and makes tuning recommendations - Investigates root cause for database related application errors (Blocking, SQL timeouts, deadlocks, unexpected data condition etc.) in real time, provides document explaining root cause and recommends fixes (including recommending changes to application stored procedures) to avoid future recurrences - Coordinates the database portion of the disaster recovery plan and participates in the planning, testing and implementation of recovery procedures - Manages SSRS data warehouse and provides guidance and assistance to reports developers working to meet business reporting requirements - Monitors and optimizes schedules for SQL Server Agent based maintenance jobs (backups, statistics maintenance, index maintenance, etc.) - Coordinates with Senior DBA staff and Engineers to provide input for capacity planning - Coordinates with Senior DBA staff to establish and document standards for database administration relevant to the RUN application - Assist application developers with complex query tuning, schema refinement, and stored procedure optimization according to company conventions and best practices - Writes or peer reviews DML scripts to correct data conditions and processes scripts through issue management system - Reviews other Database Developer's code for accuracy, standards, good coding practices, and adherence to documentation standards - Provides SQL Server DBA support for non-production SQL Server environments - Share domain and technical expertise, providing technical mentorship and cross-training to other peers and team members. - Create automation for repeating database tasks - Provide 24x7 support for critical production systems - Perform scheduled maintenance and support release deployment activities after hours Skills and Qualifications : - Solid understanding of relational database concepts and best practices - Intermediate level knowledge of SQL 2014 / 2017 Database Administration o SQL Server AlwaysOn Clusters o SQL Server Reporting Services (SSRS) o SQL Server Integration Services o SQL Profiler o Experience with scripted database maintenance o Experience troubleshooting stored procedure performance (executions plans, IO statistic) o Experience troubleshooting deadlocks o Experience with backups, restores and recovery models - Excellent knowledge of T-SQL, Stored Procedures, Functions, Triggers and Linked Servers - Exposure to enterprise-level database systems with distributed data architectures - Excellent knowledge of database monitoring, SQL Server internals and root cause analysis (Spotlight and Splunk a plus) - PowerShell and Unix shell scripting skills - Outstanding oral communication and writing skills - Strong analytical and business process skills - Strong mathematical and statistical knowledge - Ability to effectively prioritize and execute tasks under pressure to meet tight deadlines - Flexible, team player, "get-it-done" personality. Ability to multi-task and context-switch effectively between different activities and teams - Highly self-motivated and directed with an impeccable attention to detail - Experience with Azure, MongoDB, MariaDB (MySQL / NoSQL), and Redis is a plus
EDUCATION AND EXPERIENCE : Bachelor's degree in computer science or a related field 3-5 years of experience supporting enterprise SQL Server 2014 (or newer) database applications with focus on Database Administration Experience with cloud services (AWS, Microsoft Azure) a plus MCSA SQL Server or MongoDB certifications
Additional Perks :
- Excellent Market Rate / Salary
- Positive Work-Life Balance
- Competitive Benefit Packages Including Medical Insurance, Dental Insurance.
Company Overview :
