Federal Reserve System Hiring for Database Developer or Senior Database Developer at Cleveland, Ohio Full Time

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-three 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.

Database Developer

In partnership with other database and application developers, adapts business requirements, and develops the data, database specifications, and table and element attributes for an application. Documents and communicates database design. Codes moderately complex database logic and derives logical processes on technical platforms. Participates in quality assurance and develops test code. May take on several components of a project or a complex component of a project. Effectively contributes to team goals. Works beyond routine nature of tasks utilizing a specialized knowledge and technology. Troubleshoots basic problems and recommends appropriate actions.

Collaborate with Product Management, Application Architecture & Development, and Quality Assurance to provide backend designs that satisfy functional and non-functional requirements. Develop and support the design of Oracle 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. Generates deployment scripts and work with the technical support, configuration management, and operational database teams to deploy database changes to multiple environments. Support moderately complex data migrations. Provide production support through an on-call rotation with other members of the database team. Receives a moderate level of guidance and direction. Performs other duties as assigned or requested.

Knowledge & Skills

• Deep understanding of relational database design concepts.

• Moderate to strong Oracle and PostgreSQL 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.

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

• Experience with cloud data management

• Experience with NoSQL and/or DynamoDB is desirable

Education & Experience

• Two years of college or database development bootcamp certificate and 5+ years of professional work experience or

• Bachelor’s degree and 3+ years of professional work experience

Senior Database Developer

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. Provides direction to team members and is a key contributor.

Responsibilities include but are not limited to:

• 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.

• Analyze, plan, and execute data migrations as needed to support business objectives.

• Publish entity-relationship diagrams as needed.

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

Knowledge & Skills

• Deep understanding of relational database design concepts.

• Strong Oracle and PostgreSQL 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.

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

• Experience with cloud data management

• Experience with NoSQL and/or DynamoDB is desirable

Education & Experience

• Bachelor’s degree and 5+ years of professional work experience or

• Two years of college or database development bootcamp certificate and 7+ years of professional work experience

Physical Demands & General Working Conditions

Employees typically sit most of the day, work with a computer and may answer/respond to phone calls. Physical movement consists of walking for meetings, breaks, etc. Ability to lift items weighing approximately 20 pounds on a limited basis is required. Employees may be required to travel by car/air.

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 (https://www.kansascityfed.org/documents/7797/Workday_Privacy_Notice.pdf)

OUR BANK has one of the most recognizable brands around the world. The Federal Reserve is the central bank of the United States—one of the world’s most influential, trusted and prestigious financial organizations. The Federal Reserve is charged with the important mission of promoting a strong economy and a stable financial system and fulfills this responsibility by formulating national monetary policy, supervising and regulating banks and bank holding companies, and providing financial services for banks and the U.S. government.

OUR PEOPLE are diverse in background and ideas, which allows for ongoing creativity and innovation. Ultimately, they are the ones who push our high-performance, exchange-driven culture forward.

Why Our People Choose Us:

Our reputation precedes us

There will always be room for personal growth

Our people are first

You’ll find the right balance

Your responsibilities will be meaningful

We hope that you will be our future colleague.