MS SQL Developer

- Database design and architecture: Design and optimize database schemas for sales, service, spares, accounting, and other DMS modules, ensuring data integrity, normalization, and performance.
- Performance tuning: Monitor and optimize query performance, indexing, and storage utilization. Resolve database bottlenecks to support high transaction volumes.
- Data maintenance: Manage backups, restores, and disaster recovery plans. Implement data archiving and partitioning for large datasets.
- Collaboration: Work with developers, tech leads, and architects to support application requirements and design efficient APIs and data workflows.
- Cloud readiness and migration: Plan and execute production database migration to the cloud with minimal downtime. Implement hybrid strategies for on-prem staging and development environments.
- Security and compliance: Ensure compliance with data security standards, implement role-based access control (RBAC), manage encryption, and monitor vulnerabilities and audit trails.
- Monitoring and troubleshooting: Set up tools for real-time database health monitoring and promptly troubleshoot and resolve issues.
- Process and documentation: Establish standard operating procedures for database management and maintain comprehensive documentation, including schemas and workflows

Responsibilities:
- Database design and architecture: Design and optimize database schemas for sales, service, spares, accounting, and other DMS modules, ensuring data integrity, normalization, and performance.
- Performance tuning: Monitor and optimize query performance, indexing, and storage utilization. Resolve database bottlenecks to support high transaction volumes.
- Data maintenance: Manage backups, restores, and disaster recovery plans. Implement data archiving and partitioning for large datasets.
- Collaboration: Work with developers, tech leads, and architects to support application requirements and design efficient APIs and data workflows.
- Cloud readiness and migration: Plan and execute production database migration to the cloud with minimal downtime. Implement hybrid strategies for on-prem staging and development environments.
- Security and compliance: Ensure compliance with data security standards, implement role-based access control (RBAC), manage encryption, and monitor vulnerabilities and audit trails.
- Monitoring and troubleshooting: Set up tools for real-time database health monitoring and promptly troubleshoot and resolve issues.
- Process and documentation: Establish standard operating procedures for database management and maintain comprehensive documentation, including schemas and workflows.
Skills:
- Database systems: MSSQL, PostgreSQL, NoSQL, Azure SQL Database
- Query optimization: Proficient in SQL query tuning, indexing strategies, and execution plans; knowledge of SQL Server Analysis Services (SSAS)
- Programming: PowerShell scripting
- Database design: Experience in schema design, normalization, and partitioning
- Backup and recovery: Expertise in backup strategies, replication, and disaster recovery setups
- Performance monitoring: Familiarity with tools like Oracle Enterprise Manager, SolarWinds, or Nagios
- Cloud databases: Experience with AWS RDS, Azure SQL Database, or equivalent platforms
- Security: Knowledge of encryption, RBAC, and database security best practices
- Certification: Microsoft Certified Azure Database Administrator Associate preferred; ITIL Foundation certification
- ETL tools: Experience with data migration and transformation tools (e.g., Talend, Informatica)
- Scripting: Proficiency in Shell, Python, or Perl for automation
- DevOps integration: Basic understanding of CI/CD pipelines and database versioning tools (Flyway, Liquibase)
- Tools and technologies: Visual Studio
Qualifications:
- Master's or Bachelor's degree in Computer Science, Engineering, or a related field
- 15+ years of experience, including 10 years as a DBA