Senior Database Administrator

Database Administrator III – Federal Home Loan Bank, Des Moines

· What this position will be doing:

o This position will solely be responsible as the tech lead of all the databases and some of the database design. They will be administrating and maintaining the Bank’s databases. SQL and Oracle are the biggest platforms that we have. SQL is the majority, but some of the more critical things are in Oracle. A lot of the work involves working with developers and the QA team and maintaining the development spaces and supporting them. The developers create the reports, so there is not a lot of database report creation. This person will be handling updating of databases, version upgrades, monitoring performance and dealing with alerts through the day and supporting developers. Production control is all in this team’s control and all the changes are made through this team. A goal is to continue to forward with automation of database refreshes and builds. We are looking for someone who has a good depth in scripting - SQL Script or PowerShell – this is not required but would be a plus. The managed services provider, we try to give them all the routine tasks that a database administrator would do and then have full time employees working with the developers on projects. You will have to manage their tasks to make sure their work is getting done for the tasks you are sending them. This person will be helping with sets and roadmaps about where are we going to go with databases and what do we have to do to remain supported. Would consider this person to be an expert and one step above the lead because we don’t have engineers. This position will be part of an on call rotation. Issues would first go to our Managed Services team and if they can’t fix it then would come to this team.

o Hybrid schedule – 4 days in office and 1 day work from home

· Must haves:

o Bachelor’s degree in computer science or equivalent professional experience

o 5+ years of professional experience developing, tuning, troubleshooting, and supporting database systems, and data warehouses

o Advanced knowledge of database systems, including Oracle, Microsoft SQL Server (2016 – Current_, T-SQL, SSIS, and SSRS preferred

o Demonstrated ability to automate management tasks through scripts

o Experience with Security best practices

· Wants/ Preferred knowledge:

o Ability to perform basic admin tasks on Oracle 19c-Current

o Experience with Change Management in a highly regulated environment

o Experience with DB and client encryption

o Experience with RedGate Data masker and monitoring

o Experience with Rubrik

· Soft Skills:

o Self-Driven

o Can work in a group or independently

o Ability to communicate with technical and non-technical staff

· Screening Questions (Answers required for submission):

o Rate your proficiency with Microsoft SQL Server

o How big are some of the biggest databases that you’ve managed?

o Tell me about your experience with database partitioning.

o Tell me about your experience with database upgrades.

o What administrative tools have you used to manage databases?

o Rate your proficiency with Oracle Server

o Rate your proficiency with scripting and automation.

o What scripting tools are you most comfortable with?

· Interview Structure:

o 1st Round – 1 hour interview via Webex

o 2nd Round – 1 hour interview onsite

· Pay:

o $106,467 - $118,993 + 10% yearly incentive target based off Bank performance

Responsible for the build, ongoing maintenance, performance tuning, failure avoidance, detection and repair of the databases associated with the Bank’s processing environment. The DBA team is also responsible for making recommendations to ensure IT solutions are aligned with the corporate strategy and the long term success of the organization.

Accountabilities:

Key Responsibilities:

· Analyze and evaluate reported problems, take responsibility for resolution, and prevent recurrence.

· Develop, implement, administer, and maintain, logical and physical data models to support business, performance, reliability, and security requirements.

· Develop, test, implement, troubleshoot, and support data extraction, transformation, and loading processes.

· Maintain technical documentation related for the data warehouse and other database systems.

· Coach and train other employees on proper access and use of database systems.

· Assists in setting standards, guidelines, and procedures to utilize the corporate database systems.

· Support use of front-end data access, reporting, and analysis tools.

· Tune data warehouse and other database systems for optimal performance and reliability.

· Develop and maintain automation scripts using PowerShell to automate non-production data warehouse refreshes.

· Independently lead Projects, Enhancements and BAU work without oversight.

· Manage departmental internal controls and regulatory issues.

· Helps direct work of managed service providers.

Requirements:

· Bachelor’s degree in computer science or equivalent professional experience.

· 5+ years of professional experience developing, tuning, troubleshooting, and supporting database systems, and data warehouses.

· Advanced knowledge of database systems, including Oracle, SQL Server, T-SQL, SSIS, and SSRS preferred (optional DB2).