Responsibilities
- Own data warehouse production environment
- Develop and manage Release management processes
- Database maintenance –Indexing strategy
- Storage Optimization
- Performance monitoring and tuning
- Backup and Restore + disaster recovery
- Liaison with managed service operations
- Develop and maintain Configurable Items Database to facilitate database assets change management and impact analysis functionality
- Develop and maintain Master Data Management Application to facilitate control of Enterprise Master Data by business stakeholders
- Manage roll out of user dashboards, datasets using Power BI or similar BI tool
Establish and manage communications between Business Intelligence internal and external consumers (B2B and B2C).
Required Skill set
SQL / Database Expertise (Microsoft SQL Server)
- Strong SQL expertise with Microsoft SQL Server in production environments
- Experience with SQL Server installation, configuration, and maintenance
- Ability to write and optimize complex SQL queries, stored procedures, and indexes
- Knowledge of backup, restore, and disaster recovery strategies for MS SQL Server
- Understanding of performance tuning, monitoring, and troubleshooting
- Familiarity with security, roles, permissions, and access control
PostgreSQL
- Experience managing PostgreSQL databases in production
- Proven ability to install, configure, upgrade, and maintain PostgreSQL
- Strong knowledge of backup, restore, replication, and disaster recovery
- Experience with performance tuning, indexing, and query optimization
- Understanding of high-availability and failover setups
Linux / Systems
- 3+ years of hands-on experience with Linux-based systems (Ubuntu, RHEL, CentOS, Debian)
- Strong expertise in Linux system administration, networking, storage, and services
- Advanced Bash / shell scripting skills for automation and maintenance
- Experience with system performance tuning, monitoring, and troubleshooting
- Solid understanding of networking concepts (TCP/IP, DNS, firewalls, load balancing)
DevOps / Automation
- Experience building and maintaining CI/CD pipelines
- Infrastructure automation using Ansible, Terraform, or similar tools
- Hands-on experience with Docker; Kubernetes is a strong plus
- Familiarity with cloud platforms (AWS, GCP, Azure)
- Experience with monitoring, logging, and alerting systems (New Relic, Prometheus, Grafana, ELK)
Solid understanding of Dev Op principles and procedures around environment management and release management processes.
Process oriented and able to work with minimal supervision.
