Job Description

Scope:
? Database (MSSQL, Postgres & Selenium, LDAP & Oracle) migration and performance monitoring, System / data backup, disaster recovery.
? Database administration and management in cluster-based environment (capacity planning, installation, backup, recovery, monitoring, Performance optimizations, troubleshooting, load/hardware analysis mapping, security etc.)
? Daily health monitoring of production database system and data integrity checks.
? Query optimization and tuning skills, analysis and troubleshooting interactions between databases, operating systems and applications regarding performance and resources usage.
? Creating database tables, setting up indexes, data constraints and DB views Analyse, predict through trend analysis and resolve database system, storage and application issues
? Review existing software architecture and contribute to improving on the future architecture for stability and a maximum of performance
? Collect and analyse database performance information; identify and implement solutions for performance problems.
? Azure PaaS work model at DB level. (Ex: storage, TDE, Backup and restore)
? Ensuring high performance/availability of applications and providing support.
? Troubleshooting Database Functions, Store Procedure, Views.
? Carry out periodical production patch and upgrade management
? Automate and monitor huge file transfer for archiving
? Work with users and vendors to take timely and appropriate steps to resolve and troubleshoot issues impacting service levels and conduct root cause analysis
? Enforce security standards for databases & implement Data retention policies.
? Keep abreast of advances in database technologies to identify opportunities to fine tune and optimize databases and related system infrastructure.
? Troubleshoot and resolve technical problems in timely and accurate manner to improve application performance and functionality.
? User Documentation and L3 support.

Technology:

• Databases: MSSQL, Postgres & Selenium, LDAP & Oracle
• Microservices
• Rest APIs

Experience: 4+
Notice Period: Immediate
Location/ Shift Timings: Chennai \xe2\x80\x93 Flexible timings
Insights you can act on

While technology is at the heart of our clients\xe2\x80\x99 digital transformation, we understand that people are at the heart of business success.

When you join CGI, you become a trusted advisor, collaborating with colleagues and clients to bring forward actionable insights that deliver meaningful and sustainable outcomes. We call our employees \xe2\x80\x9cmembers\xe2\x80\x9d because they are CGI shareholders and owners, and, as owners, we enjoy working and growing together to build a company we are proud of. This has been our Dream since 1976, and it has brought us to where we are today\xe2\x80\x94one of the world\xe2\x80\x99s largest independent providers of IT and business consulting services.

At CGI, we recognize the richness that diversity brings. We strive to create a work culture where everyone belongs, and we collaborate with clients in building more inclusive communities. As an equal opportunity employer, we empower all our members to succeed and grow. If you require an accommodation at any point during the recruitment process, please let us know. We will be happy to assist.

Ready to become part of our success story? Join CGI\xe2\x80\x94where your ideas and actions make a difference.
Your future duties and responsibilities

Required qualifications to be successful in this role