1 month ago
Base Salary
$126k - $189k/yr
Responsibilities
- Manage, develop, and optimize very large SQL Server databases for high performance and reliability.
- Lead SQL Server performance tuning, including query optimization, indexing strategies, and database performance improvements.
- Collaborate with the DBA team on operational excellence and best practices for VLDB environments.
- Oversee data loading and ETL development using Microsoft BI tools and mentor ETL developers.
- Drive data modeling and data architecture decisions for scalable, secure, high-performance data warehouses.
- Conduct SQL and stored-procedure code reviews and enforce development and DBA best practices.
- Maintain database entitlement and permission models and implement database security measures including Transparent Data Encryption.
- Use AI tools for SQL code refactoring, performance bottleneck identification, optimization, and developer productivity.
- Coach mid-level developers and analysts, advise on work allocation, and provide technical leadership.
- Assess business and control risks, maintain regulatory compliance, and escalate issues transparently.
- Manage and implement successful projects while communicating clearly with technical and business stakeholders.
Requirements
- At least 6 years of relevant experience in application development or systems analysis.
- Extensive experience developing, maintaining, and optimizing SQL Server 2019 or later VLDB solutions.
- Expertise in SQL Server query optimization, indexing, performance tuning, and database performance enhancement.
- Deep practical knowledge of data modeling, data architecture, and data warehouse design.
- Extensive experience with data loading, ETL architecture, and Microsoft BI tools including SSIS and SSAS.
- Strong SQL code review, stored-procedure tuning, and DBA best-practice experience.
- Experience with NoSQL databases such as MongoDB or CouchDB.
- Experience managing database security, entitlements, permissions, and Transparent Data Encryption.
- Ability to use AI tools for SQL refactoring, optimization, and code-quality improvements.
- Experience managing projects and demonstrated leadership and project management skills.
- Clear and concise written and verbal communication skills.
- Bachelor’s or university degree, or equivalent experience; a master’s degree is preferred.
- Python or PySpark skills for data processing and analytics are nice to have.
Benefits
- Full-time position based in Irving, Texas, United States.
- Medical, dental, and vision coverage may be available for eligible employees.
- 401(k), life, accident, and disability insurance may be available for eligible employees.
- Wellness programs may be available for eligible employees.
- Paid vacation, sick leave, and holidays are offered through paid time-off packages.
- Eligible employees may receive discretionary and formulaic incentive and retention awards.
Tech Stack
Categories
Data Engineering
About Citi
Citi is a public financial-services company offering consumer and institutional banking, credit cards, wealth management, treasury and trade solutions, and capital-markets services. It serves individuals, corporations, financial institutions, and governments in more than 160 countries and jurisdictions, earning interest and fee income from lending, payments, trading, and advisory. Founded in 1812 and headquartered in New York, it trades on the NYSE under the ticker C.