Manage ORACLE and SQL Server DBs through multiple life cycle environments – Dev, QA, Staging and Production.
Use your deep technical knowledge to analyze and solve critical issues, providing end-to-end problem resolution.
Assist Development with complex query tuning and schema refinement.
Perform scheduled maintenance and support release deployment activities, after working hours.
Escalate from the previous tiers when necessary.
Plans and analyzes risk associated with system upgrades
Designs, implements and administers backup and disaster recovery solutions for key databases.
Helping to implement, deliver and test backups in a way which meets key Recovery Point Objectives.
Prepare and present status and technical reports as required.
Troubleshooting DB server service outages as they occur, including after-hours/weekend support.
Help define and implement DB High Availability strategies including DB Clustering and Always On availability groups.
As new applications are implemented, help choose the best Recovery Time/Recovery Point objectives, including DB High Availability strategies including DB Clustering and Always-on availability groups, log shipping, replication, etc.
Identifies faults, raise trouble tickets and provides resolution of complex problem requests.
Act as the subject matter expert for all services under service catalog and to help troubleshoot specific capacity and performance issues.
Install and configure new DB servers from scratch.
Develop and maintain capacity and performance metrics to track overall infrastructure trends
Establish and maintain Service Level Agreements (SLA) with internal and external customers and ensure the SLA standards are maintained.
Bi-weekly executive summary of the SLA measurement, program achievements and root cause analysis when SLA targets are not achieved.
Enforce, maintain, and document compliance, maximum up time and performance with all established standards
Collaborate with IT teams and management to devise a data strategy that addresses industry requirements
Job Requirements
Bachelor's degree in communication / computer engineering
5-7 years working experience in a similar environment
Experience managing Oracle RAC.
Experience Database Replication technologies (e.g., Golden Gate and Data Guard).
Experience installing, upgrading, and managing Oracle Enterprise Manager.
Strong query tuning and performance problem-solving skills.
Strong RMAN backup and recovery skills.
Strong SQL DDL, DML, and PLSQL coding skills.
Excellent verbal and written communication skills.
Database administration experience in MS SQL.
Extensive working knowledge of Windows, SQL SERVER 2008/2016/2017 including DB Clustering and Always-on availability groups, log shipping, replication, etc.
Troubleshooting SQL Server & MYSQL issues.
Experience with Database upgrade, enhancement, and migration.
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.