Senior Database Developer

10 Jun 2024

Vacancy expired!

Company Federal Reserve Bank of Cleveland

All employees must be fully vaccinated against COVID-19 which includes receiving a COVID-19 vaccine booster or qualifying for an accommodation from the Bank's COVID-19 Vaccination Policy; individuals who are unable to be vaccinated due to a medical condition or sincerely held religious belief may request an accommodation from the Bank.

The Senior Database Developer performs analysis, design, development, maintenance, and support of complex databases on multiple systems. This role is a key contributor to the development teams, providing technical direction, planning, and guidance. This role serves as a coach, and mentor to other team members when needed.

Responsibilities:
  • Collaborate with Product Management, Application Architecture & Development, and Quality Assurance to provide backend designs that satisfy functional and non-functional requirements.
  • Design and develop Oracle database structures for a critical, high-volume, high-availability web application.
  • Design and develop procedural logic using Oracle packages and procedures.
  • Assist Quality Assurance with diagnosing database-related issues and/or setting up test data.
  • Generate deployment scripts and work with the technical support, configuration management, and operational database teams to deploy database changes to multiple environments; changes may include complex data migrations.
  • Produce ad-hoc reports for a variety of different stakeholders.
  • Work with other database developers to reverse-engineer existing backend behavior.
  • Publish entity-relationship diagrams as needed.
  • Provide production support as needed.
Qualifications:
  • Bachelor's degree and 5+ years of professional work experience or
  • Two years of college or database development boot camp certificate and 7+ years of professional work experience
  • Deep understanding of relational database design concepts.
  • Strong Oracle development skills: solid SQL and PL/SQL coding techniques; ability to create and maintain tables, constraints, triggers, views, stored procedures and functions, packages, and types; solid understanding of SQL tuning practices and indexing and partitioning strategies.
  • Knowledge of, and experience with, all phases of the SDLC (software development life cycle), including requirements elicitation, design, coding, testing, and deployment.
  • Excellent verbal and written communication skills; able to communicate with technical and non-technical personnel.
  • Experience working on an n-tiered web application.
  • Experience working in an agile environment.
  • Experience as an application or operational DBA and/or knowledge of Oracle database architecture.
  • Oracle Database, Enterprise Edition, 12c or higher.
  • Toad for Oracle, or comparable database development platform.
  • Oracle SQL Developer Data Modeler, or comparable relational modeling tool.
  • Experience with PostgresSQL is desirable.
  • Experience with any of the following AWS services is desirable: (RDS, ElastiCache, DynamoDB).

Full Time / Part Time Full time

Regular / Temporary Regular

Job Exempt (Yes / No) Yes

Job Category Information Technology

Work Shift First (United States of America)

The Federal Reserve Banks believe that diversity and inclusion among our employees is critical to our success as an organization, and we seek to recruit, develop and retain the most talented people from a diverse candidate pool. The Federal Reserve Banks are committed to equal employment opportunity for employees and job applicants in compliance with applicable law and to an environment where employees are valued for their differences.

Privacy Notice

  • ID: #42726369
  • State: Ohio Cleveland 44102 Cleveland USA
  • City: Cleveland
  • Salary: USD TBD TBD
  • Job type: Permanent
  • Showed: 2022-06-10
  • Deadline: 2022-08-08
  • Category: Architect/engineer/CAD