- Responsible for the optimal performance of databases.
- Proactively monitor database systems to ensure secure and scalable services with minimum downtime by incorporating customized as well as off-the-shelf monitoring solutions/tools.
- Responsible for engaging various technology development teams to review, optimize and enhance database workloads including queries and stored procedures.
- Work with various teams to troubleshoot, identify and report database/application bugs.
- Provide database support for software development and application projects.
- Responsible for educating & mentoring developers on data modeling, indexing and querying best practices.
- Participate in multifunctional database projects which may include design, implementation, maintenance of new databases, and configuration management.
- Develop, maintain, and participate in database backup strategy and disaster recovery plans.
- Develop plans for database implementation, data source integration and data archiving and recovery.
- Document various database SOPs, maintenance plans, backup strategy, workflows as well as the overall database landscape to promote knowledge sharing among team members.
- Work with internal and external application and technology stakeholders to review status of various initiatives, compliance/regulatory changes, and contractual and/or system maintenance changes.
- Responsible for proposing and implementing database architectural changes to make database infrastructure highly scalable, secure, reliable and optimal.
- Responsible for improvement and maintenance of all databases, including patch rollouts, backup/ recovery and code deployment.
- Participate in 24x7 On-call / off-hours deployments and support.
