Senior Multi-Platform Database Lead & ETL Expert

Citi; Jersey City (NJ); On-site; USD 142,000 - 213,000; Full time

Benefits offered by this job

Medical, dental & vision coverage

401(k) plan

Paid time off & holidays

Job summary

Citi is seeking an experienced Senior Database Engineer to design, develop, and optimize enterprise database solutions across SQL Server, Oracle, PostgreSQL, MySQL, and more. You will partner with developers, data engineers, and stakeholders to deliver scalable, secure data systems supporting critical processes and reporting.

The role emphasizes performance tuning, data modeling, ETL, and automation scripting, with opportunities to contribute to cloud modernization and production reliability.

Qualifications

• 10+ years of hands-on experience with application development with a strong focus on database development.
• Strong SQL development across multiple platforms (SQL Server, Oracle, MySQL).
• Strong database design, normalization, and data modeling expertise.
• Hands-on ETL development and support.
• Experience scheduling and managing batch jobs with AutoSys or similar schedulers.
• Strong Unix/Linux administration and shell scripting experience.
• Experience with scripting languages such as Unix, Python, PowerShell, etc.
• Expertise in database performance tuning, indexing, and monitoring.
• Experience with Git/Bitbucket/GitHub/Azure DevOps.
• Knowledge of data warehousing concepts and large-scale data processing.

Responsibilities

• Design, develop, maintain, and optimize database solutions across multiple platforms.
• Develop and maintain database objects such as stored procedures, functions, views, triggers, packages, and schemas.
• Create and optimize complex SQL queries to support reporting and analytics.
• Design, develop, support, and troubleshoot ETL/ELT processes for data integration and transformation.
• Schedule, monitor, and support batch processing and data integration jobs using AutoSys or similar tools.
• Develop automation scripts using Unix/Linux shell scripting, PowerShell, Python, or equivalent scripting languages.
• Perform database performance tuning, query optimization, indexing, and capacity planning.
• Support database deployment activities and manage development, testing, and production environments.
• Implement database security standards, access controls, encryption, and auditing requirements.
• Collaborate with application development teams to design scalable data models and architectures.
• Support system upgrades, database migrations, and cloud modernization initiatives.
• Troubleshoot production issues and perform root cause analysis.
• Create and maintain technical documentation, runbooks, and operational procedures.
• Participate in on-call support and production release activities.

Skills

SQL development

Database design

ETL development

Unix scripting

AutoSys scheduling

Shell scripting

Data modeling

Performance tuning

Git / version control

Data warehousing

Education

Master's degree in Computer Science or Statistics

Tools

Git

Bitbucket

GitHub

Azure DevOps

Job description

Citi is seeking an experienced Senior Database Engineer to design, develop, and optimize enterprise database solutions across SQL Server, Oracle, PostgreSQL, MySQL, and more. You will partner with developers, data engineers, and stakeholders to deliver scalable, secure data systems supporting critical processes and reporting.

The role emphasizes performance tuning, data modeling, ETL, and automation scripting, with opportunities to contribute to cloud modernization and production reliability.