Database Specialist
Primasystems
Published Date: • Islamabad, Pakistan (On-Site)
Description
Primasystems is seeking an experienced Database Specialist with over 10 years of expertise in enterprise database architecture, administration, and data warehousing. This senior-level role involves leading the design, optimization, and management of production, staging, and test databases to ensure high performance, scalability, and availability. The candidate will play a critical role in designing and maintaining Enterprise Data Warehouse solutions supporting business intelligence, reporting, and analytics needs. Working onsite in Islamabad DHA 2, the specialist will manage a small team and provide technical leadership, mentoring, and documentation to drive efficient database operations and modernization projects. The ideal candidate has a deep understanding of database security, backup and recovery, replication and high availability, disaster recovery planning, and ETL/ELT processes. They will lead initiatives involving dimensional data modeling, SQL query optimization, deployment automation, and cloud and on-premises database integrations. Strong hands-on skills with Microsoft SQL Server, Oracle, PostgreSQL, MySQL/MariaDB, and various ETL tools are essential. The role requires a proactive approach to monitoring, troubleshooting, root cause analysis, and the ability to implement robust governance and compliance standards. This position also demands excellent communication and leadership capabilities to guide technical efforts and ensure data quality and integrity across enterprise systems.
Responsibilities
- Design, administer, and optimize enterprise production, staging, and test databases to deliver high performance and reliability.
- Lead database architecture efforts focusing on scalability, capacity planning, and performance tuning to support enterprise demands.
- Develop and maintain Enterprise Data Warehouse (DWH) solutions, including dimensional models, fact and dimension tables, data marts, and analytical data structures to facilitate BI and analytics.
- Design and manage complex ETL/ELT pipelines to integrate data from various sources such as databases, APIs, files, and cloud platforms.
- Perform advanced SQL query writing, indexing strategies, execution plan analysis, and partition optimizations to maximize database efficiency.
- Implement and maintain robust backup, recovery, replication, failover, and disaster recovery solutions to ensure data availability and integrity.
- Apply database security best practices including access control, auditing, and enforcing data quality standards to meet governance and compliance requirements.
- Drive migration, modernization, validation, and reconciliation projects for databases and data warehouses, ensuring seamless transitions with minimal disruption.
- Monitor database systems continuously, troubleshoot complex issues, conduct root cause analysis, and implement corrective actions promptly.
- Lead technical documentation efforts and mentor team members to build internal technical expertise and maintain knowledge sharing.
- Collaborate closely with cloud and on-premises infrastructure teams to ensure seamless integration and performance consistency across environments.
Experience
10 Years
Apply By
Required Skills
- MySQL/MariaDB
- SQL Server Integration Services (SSIS)
- PowerShell
- BI
- ETL
- Database Migration
- Data Warehouse Migration
- OLAP
- OLTP
- Data Modeling
- Documentation
- Mentorship
- Dimensional Modeling
- Star/Snowflake Schema Design
- Slowly changing dimensions
- Data Quality
- dbt
- Apache Airflow
- Postgres
- Database Management
- Performance Tuning
- Backup And Recovery
- SQL Query Optimization
- Database Security
- Disaster Recovery Planning
- Replication And High Availability
- Data Warehousing
- ETL Processes
- Database Design
- Indexing and Partitioning
- SQL Server
- Oracle
- Database Monitoring Tools
- SQL Server Security
- Replication and Failover Techniques
- ETL Tools
Nice to Have Skills
- Monitoring/observability
- Azure Data Factory
- BASH
- Python
- Metadata Management
- Data Lineage
- Informatica PowerCenter
- Oracle RAC
- Oracle DataGuard
- Deployment Automation
- INFORMATICA
- DWH Architecture