Database Developer or Senior Database Developer
Federal Reserve Bank of Cleveland
Cleveland, Ohio
Job Description
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.
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, permanent resident or green card holder and have resided in the U.S. for a minimum of three consecutive years.
Database Developer
Organizational Expectations:
In partnership with other database and application developers, you will 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, code moderately complex database logic, and derive logical processes on technical platforms. In this role you will participate in quality assurance and develop test code and may take on several components of a project all while effectively contributing to team goals. You will also troubleshoot problems and recommend appropriate actions.
General Responsibilities:
-
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.
Education and Experience:
-
Bachelor’s degree and 3+ years of professional work experience
-
Two years of college or database development bootcamp certificate and 5+ years of professional work experience or
Knowledge and 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.
Senior Database Developer
Organizational Expectations:
In this role you will 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 also provide direction to team members and will be a key contributor.
General 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.
-
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.
Education and 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
Knowledge and 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.
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
