23 hours ago
Pune, IndiaMid Level
Responsibilities
- Design, develop, and maintain database solutions using Oracle and Sybase.
- Develop and optimize SQL queries, stored procedures, PL/SQL packages, functions, and triggers.
- Write performance-optimized PL/SQL using Collections, Pipelined Functions, GTTs, and other advanced features.
- Monitor, analyze, and improve database performance through query tuning and optimization.
- Review Explain Plans and other performance diagnostic tools.
- Design and maintain logical and physical data models.
- Ensure data integrity, consistency, and security across databases.
- Develop and support ETL processes and data integration solutions.
- Collaborate with application developers, business analysts, and other stakeholders.
- Participate in code reviews and promote database development best practices.
- Support production deployments and troubleshoot database-related issues.
Requirements
- 4+ years of experience in database development.
- Strong hands-on experience with Oracle and Sybase databases.
- Experience supporting enterprise-scale applications and databases.
- Strong expertise in SQL and PL/SQL development.
- Strong experience writing and optimizing complex SQL queries in Oracle.
- Hands-on experience with Oracle SQL Developer and other database development tools.
- Knowledge of query performance tuning, Explain Plans, indexes, index access methods, Index Organized Tables, partitioning, joins, query optimization, stored procedures, functions, packages, and triggers.
- Basic understanding of data modeling concepts.
- Experience with ETL processes and data integration tools is preferred.
- Exposure to MongoDB or other NoSQL databases is an advantage.
- Knowledge of CI/CD pipelines and tools such as Jenkins, TeamCity, UDeploy, and SonarQube.
- Familiarity with design patterns, code reviews, coding standards, and unit testing.
- Strong analytical, problem-solving, communication, ownership, and attention-to-detail skills.
Benefits
- Full-time position within Citi’s Technology Applications Development organization.
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.