SQL Server Database Administrator (DBA) with PostgreSQL Knowledge

Job description

Position Description:

Company Profile:
Founded in 1976, CGI is among the largest independent IT and business consulting services firms in the world. With 94,000 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 2024 reported revenue is CA$14.68 billion and CGI shares are listed on the TSX (GIB.A) and the NYSE (GIB). Learn more at cgi.com.
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:

·  Performance Tuning
·  Postgre SQL
·  SQL Server Management
·  Database Administration
·  SQL

What you can expect from us:

Together, as owners, let’s turn meaningful insights into action.

Life at CGI is rooted in ownership, teamwork, respect and belonging. Here, you’ll reach your full potential because…

You are invited to be an owner from day 1 as we work together to bring our Dream to life. That’s why we call ourselves CGI Partners rather than employees. We benefit from our collective success and actively shape our company’s strategy and direction.

Your work creates value. You’ll develop innovative solutions and build relationships with teammates and clients while accessing global capabilities to scale your ideas, embrace new opportunities, and benefit from expansive industry and technology expertise.

You’ll shape your career by joining a company built to grow and last. You’ll be supported by leaders who care about your health and well-being and provide you with opportunities to deepen your skills and broaden your horizons.

Come join our team—one of the largest IT and business consulting services firms in the world.