Vacancy expired!
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.To be considered for this role, candidates must be a U.S. citizen, permanent resident or green card holder and have resided in the U.S. for a minimum of three consecutive years.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
- 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
- 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.
- 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
- 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