Job Summary :
The Python & SQL Server DBA is responsible for managing and maintaining SQL Server databases while leveraging Python for automation, data processing, and performance optimization. This hybrid role combines traditional DBA duties with scripting and automation to ensure database reliability, scalability, and operational efficiency.
Key Responsibilities :
- Install, configure, and maintain SQL Server databases across development and production environments
- Monitor database performance and optimize queries, indexes, and system configurations
- Automate administrative tasks using Python scripts (e.g., backups, health checks, alerts)
- Develop Python tools for data migration, reporting, and monitoring purposes
- Implement and manage database backup, recovery, and disaster recovery plans
- Ensure data security, access control, and compliance with organizational policies
- Collaborate with developers to support application database needs, stored procedures, and schema design
- Analyze and resolve database issues including locking, deadlocks, and performance bottlenecks
- Maintain comprehensive documentation for configurations, procedures, and automation tools
- Participate in deployments, upgrades, and capacity planning
Required Skills and Qualifications :
Bachelor's degree in Computer Science, Information Technology, or related field3+ years of experience as a SQL Server DBA and proficiency in Python scriptingStrong knowledge of T-SQL, stored procedures, indexing, and query optimizationHands-on experience with SQL Server Management Studio (SSMS) and SQL Agent JobsExperience with writing Python scripts for task automation and data processingFamiliarity with database security, backups, and high availability configurationsGood troubleshooting, documentation, and communication skillsPreferred Qualifications :
Microsoft Certified : Azure Database Administrator Associate or similar certificationExperience with REST APIs, JSON handling, and libraries like Pandas or SQLAlchemyFamiliarity with CI / CD processes and DevOps toolsExposure to monitoring tools like Redgate, SentryOne, or custom Python dashboardsUnderstanding of ETL processes and data pipelinesSkills Required
Sql Server, T-sql, Python, Query Optimization, Indexing