Cloud Database Developer or Senior Cloud Database Developer

Company

Federal Reserve Bank of Cleveland

The Federal Reserve Bank of Cleveland is part of the nation’s central bank and we’ve provided many opportunities for professional growth during our history.

For twenty-four years in a row, we’ve been named “One of Northeast Ohio’s Best Places to Work” by North Coast 99. This prestigious award honors organizations with outstanding employment practices, including compensation, benefits, training, recruitment, retention, community services, and employee communications.

Our People Make the Difference! The Federal Reserve Bank of Cleveland is seeking innovative thinkers with vision to build the framework that will carry the Bank into the future.

Follow us on LinkedIn, Twitter, Instagram, and our YouTube channel – Cleveland Fed

To be considered for this role, candidates must be a U.S. citizen.

Organizational Expectations:

In this role you will partner with other database and application developers, adapt business requirements, and develop the data, database specifications, and table and element attributes for an application.  You will also document and communicate database design.  You may drive the creation and ongoing maintenance of database management systems, standards, guidelines, and quality assurance for database deliverables, such as conceptual design, logical database, capacity planning, external data interface specification, data loading plan, data maintenance plan, and security policy. You will code moderately complex database logic and derive logical processes on technical platforms, while also participating in quality assurance and developing test code.  You may take on several components of a project and effectively contribute to team goals.  You will also troubleshoot problems and recommend appropriate actions; may provide direction to team members and is a key contributor to the team.

General Responsibilities:

• Collaborate with Product Management, Application Architecture & Development, and Quality Assurance to provide backend designs that satisfy functional and non-functional requirements.

• Design, develop and support the design of AWS Aurora database structures for a critical, high-volume, high-availability web application.

• Designs and develops database structures and procedural logic, and write any DDL, DML, and/or SQL required by the data tier of moderately complex software applications.

• 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, may also deploy automated database changes in a CI/CD pipeline; changes may include complex data migrations.

• Support moderately complex data migrations, may also analyze, plan, and execute data migrations as needed to support business objectives.

• Design and develop procedural logic using Oracle packages and procedures.

• Produce ad-hoc reports for a variety of different stakeholders.

• Ability to conduct independent research, publish entity-relationship diagrams, and working in a team environment

• Provide production support through an on-call rotation with other members of the database team.

• Performs other duties as assigned or requested.

Education and Experience:

• Database Developer: Bachelor’s degree and 3+ years of professional work experience, or 2 years of college or database development bootcamp certificate and 5+ years of professional work experience

• Senior Database Developer: Bachelor’s degree and 5+ years of professional work experience, or 2 years of college or database development bootcamp certificate and 7+ years of professional work experience

Knowledge & Skills:

Database Developer:

• Deep understanding of relational database design concepts.

• Moderate to strong AWS Aurora skills (Standing up and tearing down).

• Some Oracle experience with tablespace management.

• Comfortable working from bash console.

• Experience with Version Controlling database code (Gitlab or BitBucket).

• Experience as an application or operational DBA and/or knowledge of Oracle and PostgreSQL database architecture.

• Familiarity with AWS services/tools (S3, Glue, Athena).

• Experience with Atlassian Jira.

Senior Database Developer:

• Deep understanding of AWS Aurora with version-controlled database.

• Proficient with AWS Redshift with data transfers to/from AWS S3.