Primary DBA Functions:
- Configures and maintains Oracle Database, Microsoft SQL Server, PostgreSQL and MongoDB systems.
- Configures and supports cloud database systems DynamoDB, PostgreSQL RDS, Aurora and MongoDB.
- Performs Database maintenance (e.g., patching, upgrades, table/index reorganizations).
- Document and perform database client installations / maintenance.
- Maintains database replication between servers.
- Analyzes existing database systems and recommend improvements.
- Supports the application development lifecycle.
- Creates and maintains database objects (e.g., tables, indexes, views, stored procedures, triggers).
- Completes Request for Change tickets in a timely fashion.
- Works with Senior DBA staff on identifying and troubleshooting database issues (e.g., connectivity, performance, application errors, SQL errors).
- Works with the Security team to enforce security policies.
- Demonstrates proficient use and knowledge of standards and procedures.
- When appropriate, works with applications areas regarding database design, performance, availability, SQL, and other related issues.
DBA Maintenance Duties:
- Monitors storage and uptime for all databases (i.e., Annual Storage Report).
- Supports routine maintenance of databases in maintenance windows. Maintenance includes table re-organization, chained-row repair and other maintenance assigned by Senior DBAs.
- Works with other Platform Services staff in planning and supporting maintenance windows.
- Maintains schedule for backend jobs and communicates changes or conflicts to operations and management.
ETL Duties:
- Support the Extract Transform Load (ETL) processes used by the enterprise. Support includes:
- Mapping design and troubleshooting.
- Workflow runtime and troubleshooting.
- ETL connectivity support.
- ETL Administrative support (e.g., Manage Folders, Manage Security).
- ETL Software Upgrades and Patches.
Special Projects:
- Develops tasks needed to complete the projects. Reviews these plans with management.
- Completes documentation and cross training of DBA team on all new projects and procedures.
- Works with application development groups where appropriate in supporting these projects.
- Seeks input from the DBA staff when developing these projects.
SECONDARY FUNCTIONS: Job functions that are not essential but are considered part of the job. Other duties may be assigned.
- Works effectively with people; makes efforts to listen to internal and external customers and understand their needs. Gives high priority to customer satisfaction.
- Maintains effectiveness in varying environments, tasks, responsibilities, or people. Demonstrates willingness to adapt to change and try new things.
- Utilizes MS Word, Excel, or MS Project to develop project plans.
Skills and Abilities:
- Proficiency with Microsoft Office Tools.
- Linux knowledge.
- Experience with the following database technologies:
- 2+ years of experience as a Database Administrator focused on PostgreSQL (preferred) and/or Oracle 12c
- Experience managing and deploying Postgres in AWS using RDS
- Experience with performance tuning techniques for a heterogeneous database architecture (Redshift, PostgreSQL, Oracle)
- Experience managing temporary and permanent access to database objects
- Microsoft SQL Server
- MongoDB
- Understanding database architecture and how its components work and interact with one another.
- Ability to create an operational database and properly manage the various structures in an effective and efficient manner including performance monitoring, database security, user management, and backup/recovery techniques.
- Ability to create and troubleshoot SQL, PL/SQL, TSQL, Perl, python, bash code, and Terraform.
- Familiar with Git version control.
- Must be able to carry a pager and react to pages received on a rotation basis.
- Experience with database modeling and tools.
- Ability to work independently.
- Possess excellent troubleshooting skills.
- Possess excellent analytical skills.
- Ability to work on multiple projects simultaneously and in a fast-paced environment.
- Ability to meet deadlines.
- Demonstrates strong initiative to improve skill set.
- Demonstrates ability to apply skills learned at training to tasks assigned.
- Demonstrates flexibility.
- Displays teamwork and a positive attitude.