Cloud Database Developer or Senior Cloud Database Developer

Company: Federal Reserve Bank of Cleveland The Federal Reserve Bank of Cleveland is a part of the country's central banking system and over our history, we have provided numerous opportunities for professional growth. For twenty-four consecutive years, North Coast 99 has selected us as "One of Northeast Ohio's Best Places to Work." This prominent award recognizes organizations that excel in employment practices, comprising wages, benefits, training, recruitment, retention, community services, and employee communication. Our People Make a Difference! The Federal Reserve Bank of Cleveland is seeking visionary individuals with innovative ideas to build the structure that will sustain us into the future. Follow us on LinkedIn, Twitter, Instagram, and our YouTube channel – Cleveland Fed To be considered for this role, you need to be a U.S. citizen. Organizational Expectations: In this role, you will be collaborating with other database and application developers, adapting business needs, and creating the data, database specifications, and attributes of the table and element for an application. You will also record and relay database design. Your role may require driving the development and continual maintenance of database management systems, standards, guidelines, and database deliverables quality assurance, such as conceptual design, logical database, capacity planning, external data interface specification, data loading plan, data maintenance plan, and security policy. You will be coding moderately complex database logic, deriving logical processes on technical platforms, participating in quality assurance and developing test code. You will be a significant contributor to the team, handling several components of a project. Troubleshooting issues, recommending suitable actions, and potentially leading team members will also be a part of your responsibilities. General Responsibilities: - Collaborate with Product Management, Application Architecture & Development, and Quality Assurance to provide backend designs that meet functional and non-functional requirements. - Design, develop and sustain the design of AWS Aurora database structures for a vital, high-volume, high-availability web application. - Design and develop 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 in identifying database-related issues and/or in preparing test data. - Generate deployment scripts and partner with the technical support, configuration management, and operational database teams to deploy database changes to numerous environments; changes may include complex data migrations. - Support moderately complex data migrations and possibly plan, analyze, and execute data migrations as needed to support business objectives. - Design and develop procedural logic using Oracle packages and procedures. - Generate ad-hoc reports for diverse stakeholders. - Conduct independent research, publish entity-relationship diagrams, and work in a team environment. - Provide production support through an on-call rotation with other members of the database team. - Undertake other assigned or requested duties. 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: - Profound understanding of AWS Aurora with version-controlled database. - Proficient with AWS Redshift with data transfers to/from AWS S3. - Experience with AWS Glue and Athena services. - Experience with Oracle using Data Pump, RMAN, and Tablespace management. - Proficient with Oracle and PostgreSQL development skills: SQL and PL/SQL coding techniques. - Deployment pipeline with Infrastructure as Code (Gitlab, Ansible, Flyway, Terraform). - Experience as an application or operational DBA and/or knowledge of Oracle and PostgreSQL database architecture - Experience with unit testing of a version-controlled database. - Experience with cost controls in AWS Cloud database services. - Experience with Atlassian Jira ticket management system (Creating and Refining Jira tickets). 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 key to our success as an organization, and we seek to recruit, develop, and retain the most talented individuals from a diverse candidate pool. The Federal Reserve Banks are dedicated 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.