Participate in complex architectural discussions that involve multiple systems.
Identifyanyproduct/functionalitygapsand collaborate internal product and technology teams to define the necessary development to support solution delivery.
Drive operation excellence.
Pro-active response in identifying and troubleshooting integration or technical issues.
Challenge the status quo when needed.
Ownership and strive for excellence in your role.
Responsibilities:
MSSQL Database Administration: Proficiency in managing and optimizing MSSQL databases, including installation, configuration, and maintenance.
SQL Programming: Strong skills in SQL programming, particularly in developing and optimizing stored procedures to meet business requirements efficiently.
Debugging and Troubleshooting: Ability to identify and resolve performance issues, functional errors, and other issues related to stored procedures effectively.
Database Performance Tuning: Experience in tuning database performance by optimizing queries, indexes, and other database objects.
Database Monitoring: Familiarity with database monitoring tools and techniques to proactively identify and address performance bottlenecks, security vulnerabilities, and other issues.
Backup and Recovery: Proficiency in database backup, restore, and disaster recovery procedures to ensure data integrity and availability.
Problem-Solving Skills: Strong analytical and problem-solving skills to diagnose and resolve complex database-related issues efficiently.
Communication and Collaboration: Effective communication and collaboration skills to work closely with developers, system administrators, and other stakeholders to optimize database performance and functionality.
Requirements:
5+ years of relevant work experience in DBA Stored Procedures
Experience in database design, implementation, maintenance and troubleshooting.
Major skills into performance tuning and optimization for the database performance, then backup and recovery and security and compliance for the databases.
Should have good work experience on the store procedures.
It's good to have candidates with MS SQL and experience in PostgreSQL is an added advantage.
Microsoft certification in database administration
