Senior Database Developer

Primary Location: United States,Delaware,New Castle

Education: Bachelor’s Degree

Job Function: Technology

Schedule: Full-time

Shift: Day Job

Employee Status: Regular

Travel Time: No

Job ID: 17013748

Description

About Citi Citi, the leading global bank, has approximately 200 million customer accounts and does business in more than 160 countries and jurisdictions. Citi provides consumers, corporations, governments and institutions with a broad range of financial products and services, including consumer banking and credit, corporate and investment banking, securities brokerage, transaction services, and wealth management. Our core activities are safeguarding assets, lending money, making payments and accessing the capital markets on behalf of our clients. Citi’s Mission and Value Proposition explains what we do and Citi Leadership Standards explain how we do it. Our mission is to serve as a trusted partner to our clients by responsibly providing financial services that enable growth and economic progress. We strive to earn and maintain our clients’ and the public’s trust by constantly adhering to the highest ethical standards and making a positive impact on the communities we serve. Our Leadership Standards is a common set of skills and expected behaviors that illustrate how our employees should work every day to be successful and strengthens our ability to execute against our strategic priorities. Diversity is a key business imperative and a source of strength at Citi. We serve clients from every walk of life, every background and every origin. Our goal is to have our workforce reflect this same diversity at all levels. Citi has made it a priority to foster a culture where the best people want to work, where individuals are promoted based on merit, where we value and demand respect for others and where opportunities to develop are widely available to all. As the Senior Database Developer with DBA knowledge you will directly support the Bureau of Fiscal Services IT effort. In this role you will design, implement and maintain moderately complex databases. In addition you will:

PL/SQL Programming expertise, Database Administration tasks such as Partition/DB Maintenance, Stats collection for large tables/Staging tables.

Experience with efficient query design, performance tuning, a good understanding of Oracle Optimizer and features.

Collaboration with DBAs, Application Development teams, and other partners.

Develop database functionality in accordance with project deliverables.

Knowledge and implementation of Database encryption.

Develop and maintain expertise in use of automated tools for database design and implementation.

Design and maintain logical and physical data models (relational & dimensional), data dictionary and database volumetric.

Performance tuning problematic areas of database tables, indexes, functions and stored procedures.

Have hands on experience with database upgrades.

Advise applications development staff and users on database solutions to business problems, data architectures, data base management system facilities and capabilities.

Qualifications

Technical Skills Required:

• 5+ years industry experience with Oracle 10g/11g/12c
• Understanding and operability of an Unix / Linux environment
• Understanding of related middleware technologies, in the area of Java (ADF, Apache, WebLogic, JRE)
• Expert in PL/SQL, Stored Procedures and Performance Tuning.
• Experience with development related end-to-end DB setup using DDL/DML
• Experience with Oracle Data Guard, Oracle Grid Control, Oracle Diagnostics and Tuning Packs
• Experience with Shell scripting including vi and general file management commands.
• Experience with database partitioning in range, list, hash or similar
• Understanding of high availability, database failover models, hardware architectures, SAN administration, scripting, and print management
• Experience in code migration, database change management and data management through the various stages of the development life cycle
• Experience with RMAN and knowledge of ALL Oracle backup and recovery scenarios

Non-Technical Skills Required:

• Excellent verbal and written communication skills
• Ability to handle multiple projects and deadlines
• Self-motivated with a passion for technology
• Able to work independently as well as in a team environment
• Ability to pick up new concepts and apply the knowledge
• Understanding of financial concepts

Basic Qualification:

• 5+ years industry experience in an Oracle Developer role with DBA knowledge
• Masters/Bachelor’s degree in Computer Science related field
• Advanced degree or Oracle Certification is a plus