Senior O&M Database Engineer

Job Description

As a SQL Database Engineer responsible for providing technical support, troubleshooting issues, and optimizing databases to ensure the reliability and performance of our database environments.

• Align with Business Goals
• Familiarize with the company's mission, vision, and strategic objectives.
• Work closely with other departments.
• Clearly articulate technical concepts to non-technical stakeholders.
• Forecast future network needs and plan for capacity expansion.
• Install, configure, and maintain database systems (e.g., SQL Server, MySQL, PostgreSQL, Oracle).
• Perform database backups and recovery operations.
• Monitor database performance and implement optimization techniques.
• Manage user access and permissions.
• Diagnose and resolve database-related issues.
• Troubleshoot performance bottlenecks and implement solutions.
• Analyze and optimize SQL queries for improved performance.
• Create and maintain indexes to optimize query execution.
• Plan and execute database migrations.
• Migrate data between different database platforms.
• Database support and operations often require 24/7 coverage, so shift work may be necessary.
• Being on call to respond to urgent issues outside of regular working hours may be required.
• Maintain clear, up-to-date documentation on DB solution configurations, policies, and operational procedures.
• Prepare reports on incidents, system performance, and solution effectiveness with a Root cause analysis.
• Optimize performance and capacity.
• Anticipate future needs and develop a roadmap for modernization.
• Prioritize activities
• Monitor and respond promptly to incidents.
• Optimize Performance
• Track metrics.
• Fine-tuning
• Keep abreast of the latest technologies
• Understanding Level Designs
• Maintain clear, up-to-date documentation on solution configurations and operational procedures.
• Prepare reports on incidents, system performance, and solution effectiveness with a Root cause analysis.
• Staying up to date with the latest technologies.

Personal Skills

• Strong Team Management Skills.
• Excellent communication, interpersonal and negotiation skills
• Excellent problem-solving skills
• Excellent presentation skills.

Technical Skills

• Strong understanding of SQL Server or MySQL.
• Experience with database administration tasks.
• Proficiency in SQL query writing and optimization.
• Knowledge of database design principles.
• Experience with scripting languages (e.g., PowerShell).
• Understanding database maintenance best practices.
• Strong problem-solving and troubleshooting skills.
• Excellent communication and interpersonal skills.
• Design, implement, and maintain highly available and scalable database solutions on cloud platforms.
• Develop and implement database backup and recovery strategies.
• Monitor database performance and proactively identify and resolve issues.
• Perform database capacity planning and performance tuning.
• Work with development teams to optimize database schemas and queries.
• Execute basic SQL queries for data retrieval and analysis.
• Querying Microsoft SQL Server Databases at Microsoft
• Designing Microsoft SQL Server Databases at Microsoft.
• Database administrator fundamentals.
• Microsoft .Net Fundamentals.
• Administering Microsoft SQL Server Databases at Microsoft.
• Performance Tuning and Optimizing SQL Databases.
• SQL Server 2008-2012 Analysis Services at Microsoft.
• SQL Server 2014: Performance and Optimization at Microsoft.
• SQL Server 2016: Always On Availability Groups in Azure at Microsoft.
• Ability to work under pressure and respond to incidents effectively.

Job Details

Preferred Candidate