This position is responsible for providing production database operations, ensuring performance and scalability, high availability and disaster recovery, compliance and security of database servers.
Additional responsibilities include developing best practices and repeatable procedures for deploying databases, day-to-day operational activities including break/fix, space management, backup and restore, performance monitoring and tuning. The individual filling this role supports recommendations for physical database design, architecture, and testing of database technologies. Writes code for database access, modifications, and constructions including stored procedures. Maintains version control for promoting changes into production environments for both database and applications technologies. Has good understanding of storage systems and various application integration architectures. Supports production environments 24x7.
DUTIES
1. Provide tier 2 support and maintenance of applications and database to meet daily operational needs. May act as escalation point if needed
2. Troubleshoot performance, stability, and availability issues in a high volume and highly transactional database environment
3. Perform routine and regular application and database maintenance operations. Build, document, and deploy database objects based upon best practices and standards
4. Install, upgrade, and configure applications and database software and replication and implement and maintenance complex database security
5. Manages databases through multiple product lifecycle environments, from development to mission critical production systems.
6. ERP, CRM, Database tuning, performance monitoring, capacity management and automation tasks
7. Apply application and database updates and stand-alone hotfixes to environments, as well as evaluate and make recommendations for improvement to processes for database management.
8. Conduct application and database maintenance, maintains database backups, while also triaging and troubleshooting database alerts and issues, identifying root cause, and launching corrective actions.
9. Independently analyzes, solves, and corrects issues in real time, providing problem resolution end-to-end.
10. Refines and automates regular processes, tracks issues, and documents changes.
11. Assists developers with complex query tuning and schema refinement.
12. Provides 24x7 support for critical production systems. Participates in an On-Call rotation as needed
13. Performs scheduled maintenance and support release deployment activities after hours.
14. Shares domain and technical expertise, providing technical mentorship and cross training to other peers and team members.
15. Installs, configures, patches, and upgrades database servers. Manages on-prem and cloud based (Azure-preferred) database servers and services in PaaS and IaaS cloud solutions.
16. Provides high availability solutions for multiple database configurations.
17. Uses experience in disaster recovery solutions and best practices to create, maintain, and verify backups using native and 3rd party solutions. Discusses RPO and RTO strategies with business leaders.
18. Performs more advanced performance monitoring and troubleshooting. Creates execution plans, uses database optimizers, and has experience using database-specific monitoring technologies.
19. Applies a cybersecurity mindset and best practices to secure Database servers. Interacts/guides audit and compliance teams. Uses data security/encryption mechanisms (e.g., TDE, data masking/redacting/subsetting). Hardens database servers based upon security hardening requirements. Assists with security audits from internal and external providers.
20. Identifies and resolves capacity issues. Regularly monitors/reviews performance metrics to identify trends and future risks in the environment before they happen and works with leadership to get the work prioritized. Partners with the Enterprise Systems Services team on physical design and implementation of database infrastructure
21. Identifies, troubleshoots, and resolves performance issues including expensive SQL queries, blocking/deadlocking, excessive waits, etc.