Position Description:
Company Profile:
Founded in , CGI is among the largest independent IT and business consulting services firms in the world.
With 94, consultants and professionals across the globe, CGI delivers an end-to-end portfolio of capabilities, from strategic IT and business consulting to systems integration, managed IT and business process services and intellectual property solutions.
CGI works with clients through a local relationship model complemented by a global delivery network that helps clients digitally transform their organizations and accelerate results.
CGI Fiscal reported revenue is CA$14.68 billion and CGI shares are listed on the TSX (GIB.A) and the NYSE (GIB).
Learn more at .
Position - SQL Server DBA with Postgres Knowledge
Job Title: SQL Server Database Administrator (DBA)
Position: Software Engineer
Experience: 4- 7 Years
Category: Software Development/ Engineering
Shift: Timing/rotation etc.
details
Main location: Mumbai, Chennai, Bangalore
Employment Type: Full Time
Job Description -
We are seeking a skilled SQL Server Database Administrator (DBA) with hands-on experience in PostgreSQL to manage, maintain, and optimize our database infrastructure.
The ideal candidate will play a critical role in ensuring the reliability, performance, and security of our SQL Server and PostgreSQL database environments, working closely with development and DevOps teams.
Your future duties and responsibilities:
Key Responsibilities:
• Administer, monitor, and maintain Microsoft SQL Server and PostgreSQL databases across development, test, and production environments.
• Perform database performance tuning, query optimization, and capacity planning.
• Manage backups, restores, disaster recovery, and high availability strategies (e.g., Always On, Log Shipping, Replication, etc.).
• Support database migrations and conversions between SQL Server and PostgreSQL.
• Work with development teams to assist in the design of database schemas, indexes, and stored procedures.
• Automate regular DBA tasks using PowerShell, T-SQL, pgAdmin, or scripting languages.
• Monitor and analyze database performance using tools like SQL Server Profiler, Performance Monitor, and pg_stat_statements.
• Stay up to date with the latest database technologies, security patches, and industry best practices.
Required qualifications to be successful in this role:
Required Qualifications:
• 4+ years of hands-on experience with SQL Server
• 1+ years of experience working with PostgreSQL in a production environment.
• Strong proficiency in T-SQL and PL/pgSQL.
• Experience with database migration tools and techniques (e.g., AWS DMS, ora2pg, pgloader).
• Familiarity with cloud platforms like Azure, AWS, or GCP and managed database services (e.g., Amazon RDS, Azure SQL, Cloud SQL).
• Solid understanding of indexing, partitioning, and query execution plans.
Preferred Skills:
• Experience with Linux and Windows Server environments.
• Knowledge of CI/CD pipelines and integration of database changes in DevOps workflows.
• Familiarity with monitoring tools.
• Certification(s) in Microsoft SQL Server or PostgreSQL.
Skills: