Position Description
We are seeking an experienced Senior Application Support Specialist / Database Administrator (DBA) with extensive expertise in enterprise application support, database administration, incident management, and application development.
The ideal candidate will have over 8 years of experience supporting business critical applications in complex IT environments, with strong technical proficiency in UNIX/Linux, SQL, shell scripting, and relational database management systems.
This role requires a combination of hands-on technical troubleshooting, database management, application maintenance, and production support to ensure the availability, stability, performance, and reliability of enterprise applications.
On-Call Support Required
Hybrid working model - 3 days in office
Your future duties and responsibilities
- Application Support and Incident Management
- Provide Level 2 and Level 3 technical support for enterprise applications and databases.
- Investigate, troubleshoot, and resolve application incidents, system errors, and data related issues.
- Monitor application health, availability, and performance to ensure uninterrupted business operations.
- Perform root cause analysis and implement corrective actions to prevent recurring incidents.
- Support business critical applications requiring 24/7 operational availability.
- Collaborate with development teams, infrastructure teams, and business stakeholders to resolve complex technical issues.
- Database Administration and Support
- Administer, maintain, and support relational database management systems, including DB2, Oracle and Sybase SQL Server.
- Perform database refreshes, backups, and routine maintenance activities.
- Investigate and resolve database related incidents, data inconsistencies, and application data issues.
- Develop and execute SQL queries, scripts, and database procedures to support operational requirements.
- Perform database analysis, design, and development activities.
- Support data extraction, analysis, and reporting requests from business users.
- UNIX/Linux and Automation
- Develop, maintain, and troubleshoot UNIX/Linux shell scripts used for application and database operations.
- Automate recurring operational activities and application support processes.
- Analyze application logs, system processes, and batch execution results to identify and resolve technical issues.
- Support data processing activities and downstream application integrations.
- Utilize SQL, shell scripting, Perl, and AWK to investigate and resolve production issues.
- Application Maintenance and Release Support
- Participate in application releases, deployments, and production implementation activities.
- Support application enhancements, maintenance activities, and technical changes.
- Collaborate with development and project teams to ensure successful production deployments.
- Troubleshoot issues arising from application releases and system changes.
- Provide technical expertise during application development, testing, and implementation activities.
- Technical Leadership and Collaboration
- Provide technical guidance to application support teams.
- Coordinate incident investigation and resolution activities.
- Support the operational performance and stability of multiple enterprise applications.
- Work closely with technical teams and business stakeholders to address production issues.
- Contribute to knowledge sharing and continuous improvement of application support processes.
Required Qualifications To Be Successful In This Role
- 15+ years of experience in information technology, including application support, database administration, and application development.
- Extensive experience supporting enterprise applications in production environments.
- Strong experience with UNIX/Linux operating systems and shell scripting.
- Advanced SQL knowledge and experience troubleshooting complex database issues.
- Hands on experience with relational databases such as DB2, Oracle, and Sybase SQL Server.
- Experience with database design, development, maintenance, backups, and refreshes.
- Experience investigating and resolving production incidents and application performance issues.
- Experience supporting application deployments and production releases.
- Ability to analyze data issues and develop SQL based solutions and reports.
- Strong analytical, troubleshooting, and problem-solving skills.
- Ability to work independently and collaborate effectively with cross functional teams.
Technical Skills
Operating Systems and Scripting
- UNIX/Linux
- UNIX/Linux Shell Scripting
- Perl
- AWK
- SQL
- PL/SQL
- T SQL
Database Technologies
- IBM DB2
- Oracle Database
- Sybase SQL Server
- Relational Database Management Systems (RDBMS)
- Database Design and Development
- Database Administration
Development and Support Tools
- PowerBuilder
- PowerDesigner
- DbArtisan
- TortoiseSVN
- GitDesktop
- VuGen
- VBA
- Microsoft Office Suite
Core IT Competencies
- Application Management Services (AMS)
- Production Application Support
- Incident Investigation and Resolution
- Database Administration and Maintenance
- Application Monitoring and Troubleshooting
- Data Analysis and Reporting
- Application Design and Development
- Production Deployments and Release Support
- Technical Team Leadership
Preferred Experience
- Experience supporting enterprise applications within financial services, securities administration, telecommunications, or government environments.
- Experience supporting applications with high availability and continuous data processing requirements.
- Experience providing technical leadership within application management and support teams.
- Experience working with legacy applications and multiple database technologies.
- Experience providing end to end application and database support, from development through production maintenance.
Ideal Candidate Profile
The ideal candidate is a seasoned IT professional with a strong background in application support and database administration, capable of managing complex production environments and resolving critical technical issues.
The candidate should demonstrate strong SQL and UNIX/Linux scripting expertise, practical knowledge of enterprise database technologies, and the ability to support applications throughout their lifecycle.
A combination of technical troubleshooting skills, application development experience, database expertise, and operational leadership is essential for success in this role.
CGI is providing a reasonable estimate of the pay range for this role. The determination of this range includes factors such as skill set level, geographic market, experience and training, and licenses and certifications. Compensation decisions depend on the facts and circumstances of each case. A reasonable estimate of the current range is $60,000–$95,000.
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.
At CGI, we value the strength that diversity brings and are committed to fostering a workplace where everyone belongs. We collaborate with our clients to build more inclusive communities and empower all CGI partners to thrive. As an equal-opportunity employer, being able to perform your best during the recruitment process is important to us. If you require an accommodation, please inform your recruiter.
That same commitment to fairness extends to how we use technology. To support our recruitment team, AI tools may be used to help assess applications though they never replace human judgement. All hiring decisions remain entirely in the hands of our recruitment professionals.
To learn more about accessibility at CGI, contact us via email. Please note that this email is strictly for accessibility requests and cannot be used for application status inquiries.
Come join our team - one of the largest IT and business consulting services firms in the world.
