Senior Database Administrator

Job Summary

The Senior Database Administrator is responsible for designing, developing, and optimizing enterprise database systems across SQL Server, Azure SQL, and hybrid cloud environments. This role leads database development initiatives, implements secure and efficient migration strategies, and supports both relational and non-relational data platforms. This role provides advanced Tier 2/3 troubleshooting for performance and operational issues, ensuring high availability, regulatory compliance, and data protection. Additionally, this position collaborates with cross‑functional teams to integrate databases with applications, support ETL workflows, and enable scalable cloud-based solutions. The role also includes performance monitoring, capacity planning, disaster recovery preparation, and maintaining comprehensive documentation to support reliable and resilient data operations.

Key Responsibilities

1. Database Development: Develop and performance optimize databases primarily on SQL Server and Azure SQL platforms, with exposure to AWS and Databricks and PostgreSQL environments; automate daily tasks using T-SQL and similar administrative tools (SSIS, Python)
2. Database Migration: Develop and apply migration strategies between Cloud and on-prem systems to maintain data platform operations.
3. Database Design and Implementation: Design, deploy, and manage relational and non-relational databases, including schema development, indexing, and partitioning to support enterprise applications.
4. Troubleshooting and Support: Diagnose and resolve database issues, such as performance bottlenecks, errors, or failures, providing Tier 2/3 support for data-related incidents.
5. Security and Compliance: Implement and enforce database security policies, including user access controls, encryption, auditing, and adherence to regulations (e.g., PCI-DSS) to safeguard sensitive data.
6. Performance Monitoring: Monitor database performance using tools like SQL Server Management Studio, Oracle Enterprise Manager, or Prometheus, identifying and optimizing slow queries or resource usage.
7. Collaboration: Work with developers, analysts, and IT teams to integrate databases with applications, support ETL processes, and enable cloud-based data solutions.
8. Documentation: Create and maintain detailed database documentation, including ER diagrams, data dictionaries, and recovery procedures.
9. Capacity Planning: Evaluate current and projected data storage needs, recommending scaling solutions or migrations to accommodate business expansion.
10. Disaster Recovery: Develop, test, and maintain Fabric database replication and copy jobs. Design, document, and regularly test failover and disaster recovery strategies to ensure minimal downtime and data loss.