
Job Overview
Employment Type
Full-time
Compensation
Salary
Range $95,500.00 - $134,400.00
Benefits
Medical insurance
Dental Insurance
vision coverage
401(k) Plan
Life insurance
Disability insurance
wellness programs
Paid Time Off
Paid holidays
Job Description
Citi is a globally recognized financial services company with a strong commitment to innovation, technology, and delivering high-quality services. As one of the world’s leading banks, Citi provides a wide range of financial products and services to consumers, corporations, governments, and institutions. Established with a rich history of excellence and a global presence, Citi continually invests in advanced technological solutions to support its vast and complex operations worldwide. The company’s focus on digital transformation and data-driven decision-making underscores the importance of robust data platforms and the need for leading-edge database management expertise.
The Lead SQL Server Development & DBA-Level Engineer role is crucial within Citi’s technology division, particularly in the Applications Development job family group. Operating full-time at the Irving, Texas location, this position commands a salary range of $125,760 to $188,640 annually, reflecting the advanced skills and leadership responsibilities involved. This role is tailored for an experienced engineer who specializes in Microsoft SQL Server environments, especially with very large databases (VLDBs). The candidate will lead initiatives to develop scalable and high-performance data solutions that support critical business objectives.
This leadership role entails a blend of hands-on technical expertise and the ability to mentor and guide junior team members. The successful candidate will manage and optimize very large databases on SQL Server version 2019 and above, focusing on performance tuning, query optimization, and advanced indexing strategies to ensure database reliability and efficiency. Collaboration with a dedicated DBA team is essential to maintain operational excellence and to promote best practices across the VLDB environment.
Additionally, the role oversees data loading and ETL development using Microsoft BI tools such as SSIS and SSAS. The lead engineer will mentor ETL developers, shaping the architecture of data pipelines to handle large-scale data volumes effectively. They will also be responsible for driving data architecture and modeling efforts to ensure data integrity, security, and performance within data warehouses.
Quality assurance through rigorous SQL code reviews and enforcement of best practices forms a key part of this position. The individual will manage database security, including entitlements, permissions, and encryption methods like Transparent Data Encryption (TDE), to safeguard sensitive information.
The role also introduces innovative approaches by leveraging AI tools to enhance SQL development, assisting with code refactoring, identifying performance bottlenecks, and optimizing workflows to improve developer productivity. As a leader, the candidate will mentor mid-level developers and analysts, oversee project implementation, and conduct thorough risk assessments to uphold compliance and ethical standards.
Citi values candidates with strong communication skills, project management experience, and a proven track record in delivering successful, technology-driven projects. While not mandatory, additional skills in Python or PySpark for data processing, as well as familiarity with NoSQL databases like MongoDB or CouchDB, are advantageous.
This position offers a challenging and rewarding opportunity to work at the forefront of database technology in a top-tier financial institution, where innovation meets large-scale business impact. With comprehensive benefits and a supportive workplace culture, Citi encourages professionals seeking excellence and growth to apply for this critical leadership role in SQL Server development and database administration.
The Lead SQL Server Development & DBA-Level Engineer role is crucial within Citi’s technology division, particularly in the Applications Development job family group. Operating full-time at the Irving, Texas location, this position commands a salary range of $125,760 to $188,640 annually, reflecting the advanced skills and leadership responsibilities involved. This role is tailored for an experienced engineer who specializes in Microsoft SQL Server environments, especially with very large databases (VLDBs). The candidate will lead initiatives to develop scalable and high-performance data solutions that support critical business objectives.
This leadership role entails a blend of hands-on technical expertise and the ability to mentor and guide junior team members. The successful candidate will manage and optimize very large databases on SQL Server version 2019 and above, focusing on performance tuning, query optimization, and advanced indexing strategies to ensure database reliability and efficiency. Collaboration with a dedicated DBA team is essential to maintain operational excellence and to promote best practices across the VLDB environment.
Additionally, the role oversees data loading and ETL development using Microsoft BI tools such as SSIS and SSAS. The lead engineer will mentor ETL developers, shaping the architecture of data pipelines to handle large-scale data volumes effectively. They will also be responsible for driving data architecture and modeling efforts to ensure data integrity, security, and performance within data warehouses.
Quality assurance through rigorous SQL code reviews and enforcement of best practices forms a key part of this position. The individual will manage database security, including entitlements, permissions, and encryption methods like Transparent Data Encryption (TDE), to safeguard sensitive information.
The role also introduces innovative approaches by leveraging AI tools to enhance SQL development, assisting with code refactoring, identifying performance bottlenecks, and optimizing workflows to improve developer productivity. As a leader, the candidate will mentor mid-level developers and analysts, oversee project implementation, and conduct thorough risk assessments to uphold compliance and ethical standards.
Citi values candidates with strong communication skills, project management experience, and a proven track record in delivering successful, technology-driven projects. While not mandatory, additional skills in Python or PySpark for data processing, as well as familiarity with NoSQL databases like MongoDB or CouchDB, are advantageous.
This position offers a challenging and rewarding opportunity to work at the forefront of database technology in a top-tier financial institution, where innovation meets large-scale business impact. With comprehensive benefits and a supportive workplace culture, Citi encourages professionals seeking excellence and growth to apply for this critical leadership role in SQL Server development and database administration.
Job Requirements
- Bachelor’s degree or university degree or equivalent experience
- 8+ years of relevant experience in applications development or systems analysis with extensive SQL Server expertise
- Proven and extensive experience in developing, maintaining, and optimizing solutions for very large databases (VLDBs) in SQL Server 2019 and above
- Demonstrated ability in performance tuning for SQL Server including query optimization and advanced indexing
- Deep understanding and practical experience in data modeling principles, data architecture, and data warehouse design
- Extensive experience with data loading processes and ETL development using Microsoft BI tools (SSIS, SSAS)
- Strong experience in SQL code reviews and inculcating DBA best practices within development teams
- Proven experience in managing database security and familiarity with Transparent Data Encryption (TDE)
- Ability to leverage AI tools for SQL code refactoring and optimization
- Experience in managing and implementing successful projects with demonstrated leadership skills
- Consistently demonstrates clear and concise written and verbal communication
Job Qualifications
- Bachelor’s degree or equivalent experience
- 8+ years experience in applications development or systems analysis with extensive SQL Server expertise
- Proven expertise in managing and optimizing very large databases (VLDBs) in SQL Server 2019 and above
- Demonstrated ability in SQL Server performance tuning and query optimization
- Deep knowledge of data modeling, data architecture, and data warehouse design principles
- Extensive experience in data loading and ETL development using Microsoft BI tools such as SSIS and SSAS
- Strong skills in SQL code reviews and applying DBA best practices
- Proven experience in database security management including permission models and database encryption
- Ability to leverage AI tools for SQL development enhancements
- Experience in project management and leading successful technology projects
- Excellent written and verbal communication skills
- Nice to have: Python/PySpark skills
- Experience with NoSQL databases such as MongoDB or CouchDB
- Master’s degree preferred
Job Duties
- Manage, develop, and optimize solutions for very large databases (VLDBs) in SQL Server version 2019 and above
- Lead performance tuning efforts including query optimization and advanced indexing
- Collaborate closely with the DBA team to ensure best practices and operational excellence
- Oversee data loading and ETL development using Microsoft BI tools and mentor ETL developers
- Drive data architecture and modeling for data warehouses ensuring data integrity, scalability, and security
- Conduct SQL code reviews to maintain quality and adherence to best practices
- Manage database security including entitlement models and implement encryption methods like TDE
- Leverage AI tools to assist in code refactoring, performance optimization, and productivity enhancement
- Mentor mid-level developers and analysts including work allocation
- Assess risks in business decisions ensuring compliance and ethical judgment
Job Location
Your Profile Is Visible To Hiring Managers Across OysterLink.
We'll match you with best jobs
Get job offers faster


Search For More Opportunities:
How Candidates Get Hired Faster
Apply to 2–3 similar roles
Complete profile & get best matches
Check new opportunities daily

