Senior Data Base Administrator

Job Description

• Database Administration experience with on-premise and cloud-based environments.
• Experience working on MySQL/Postgres/AWS RDS MySQL/Aurora /Postgres/Amazon Redshift environment.
• Experience working on OCI – DBCS, ADW environment.
• Administration experience with NoSQL databases – Mongo.
• Should have enough knowledge on AWS services like EC2, S3, IAM roles/policies and AWS cloud governance.
• Should know how to migrate the database to AWS RDS using DMS & Schema conversion tool.
• Experience in scripting RDS MySQL backup and restore across environments.
• Knowing working with CLI command line tools like AWS CLI & OCI CLI.
• Proactive monitoring of databases both from a performance and capacity management perspective.
• Experience with backups, restores, and recovery models. Proactive housekeeping/archiving.
• Experience in Performance Tuning and Optimization, using native monitoring and troubleshooting tools.
• Should have enough knowledge on OCI services like DBCS, Autonomous services, cloud storage, notifications, and alarms.
• Experience in monitoring Oracle databases via SQL developer, OMC tool, OCI metrics & performance hub.
• Experience in implementing Oracle alerts via OCI alarm & metrics.
• Experience in monitoring ASM usage and archive log usage via scripting.
• Should have enough knowledge in troubleshooting Oracle tablespace issues, index issues & database mount issues.
• Familiar with Oracle CDBs and PDBs and experience in moving PDBs across environments.
• Should know about administrating and working with the ADW database.
• Experience in working with wallets and the ability to create password-less wallets.
• Familiarity with Database Monitoring and alerting tools – SolarWinds DPA, Cloud Watch, Ops genie.
• Administration experience on SolarWinds DPA monitoring tools like application upgrades, rebuilding prod app data on non-prod environment, agent monitoring & configuring alerts.
• Experience in troubleshooting and resolving database problems using various troubleshooting tools.
• Ability to detect troubleshoot and resolve database-related CPU, memory, I/O, disk space, and other resource contention issues.
• Experience in implementing operational automation using Shell/Perl/Python scripts.
• Perform database maintenance activities such as backup/recovery, replication, rebuilding, and reorganizing indexes.
• Experience in troubleshooting and resolving database integrity issues, performance issues, blocking/deadlocking issues, connectivity issues, data replication issues, etc.
• Experience in raising support tickets with various vendors like AWS, Oracle, and Solar winds working with them, and getting issues to the closure.
• Good interpersonal, communication, and documentation skills. requirement.

‍

‍