SQL DBA

Job Description

Position Overview:        

This position is responsible for managing and maintaining all databases in the Company to meet defined SLAs. This role will primarily ensure database resources on Azure and AWS are consistently available, accessible, optimized, backed up, monitored, and secure. This position will be responsible for database tasks such as schema design, performance tuning, capacity planning, upgrades, patching, and change control activities. This position also entails all activities associated with the management and operations of lower database environments, and working closely with developers, system administrators, quality engineers to ensure system availability, continuity, data integrity and performance of production databases. 

• Tune PostgreSQL and MSSQL databases on AWS and Azure to reduce cost.
• Support all activities associated with PostgreSQL and MSSQL databases.
• Support the production environment by proactively managing the performance, integrity, and security of all applications' databases and database servers.
• Design, create and maintain highly available and secure database instances.
• Perform under limited supervision, maintain reliability of data and databases, and assist in developing and implementing standards for database maintenance and configuration.
• Mentor and provide support to developers in best practices for database design, programming, and tuning. 
• Responsible for database administration including database system architecture, configuration, database creation, security, performance tuning and monitoring, backup and recoveries, database replication, failover strategies, data partitioning and scripting.
• Conversant with AWS RDS, Aurora, and Microsoft SQL Servers.
• May write PL/SQL code to load, migrate, summarize, and analyze data in support of application developers and other business objectives.
• Consult with developers to optimize query performance and provide best practice.
• Prepare / review implementation plans for major code pushes on production systems.
• Document all changes, upgrades, maintenance, and procedures following controls.
• Analyze products and recommend to senior management.
• Participate in an on-call rotation that provides 24x7x365 support of critical systems.
• Plan growth and changes (Capacity planning) on servers and databases
• Work closely with other team members for effective IT operations and business continuity
• Provide an effective Disaster Recovery strategy for the infrastructure on AWS and Azure