Database Administrator

Preferred Education:
Bachelors degree

Required Skills Qualifications and Experience:
3 years of experience as a Database Administrator (DBA) or in a similar database management role
Work experience with relational database management systems (RDBMS) such as Microsoft SQL Server AWS Aurora Oracle or PostgreSQL
Work experience working in Linux Windows environments and with AWS database technologies.
Work experience with database design schema development and optimization techniques
Work experience with database backup and recovery techniques including high availability configurations
Work experience with performance tuning monitoring and troubleshooting techniques
Knowledge of database security practices including user roles access controls and encryption
Experience with cloud-based database environments such as AWS RDS and/or EC2
Experience with Structured Query Language (SQL) and GitHub version control
Development of clean readable and easy to support Python code
Excellent communication skills and the ability to convey complex technical concepts to non-technical stakeholders
Customer-focused orientation with proficiency in iterative development practices
Self-starter and comfortable working autonomously

Preferred Skills Qualifications and Experience:
5 years of work experience as a Database Administrator (DBA) or in a similar database management role
Bachelors degree in Computer Science or Information Systems or related field
Work experience with cloud data warehouse systems such as AWS Redshift or Snowflake
Work experience in Python R Java C
Certifications in database technologies such as Microsoft Certified: Database Administrator or Oracle DBA
Knowledge in designing Data Governance solutions with Informatica Data Quality Data Lineage and Data Catalogs

Clients mission is to serve the public by providing safe reliable and accessible transportation. Clients core values are built around safety service equity and sustainability and each employee that works for the Clients performs their roles based on our vision mission and values.

As a database administrator you will report to the Manager of Database Administration and play a substantive role in implementing managing securing database technology and exploring methods to implement database tuning and performance optimization. The database administrator will assist with the development and contribute to policies and procedures to ensure the security and integrity of approximately 40 mission-critical on-prem and cloud databases.

Along with technological expertise this individual should have a customer service disposition. This individual should be comfortable in a fast-paced setting and be able to foster a congenial team environment.

Responsibilities:
Coordinate the monitoring of the database health and performance and troubleshoot issues and implement ensure high level of availability and database security.
Assist with migration from older database versions to newer versions.
Assist with database server infrastructure and software analysis and recommendations.
Participate in projects associated with the enhancement upgrade/patching or implementation of new or existing technology solutions.
Support database maintenance and disaster recovery processes.
Assist with database setup configuration and upgrades.
Ensure databases are backed up appropriately and can be restored if necessary
Maintain database access security and database integrity
Stay abreast of the latest developments in database administration and apply innovative approaches to solve database administration challenges.
Perform final review and approve the scheduled database tasks including Jobs Alerts Emails and Notifications.
Collaborate with cross-functional teams such as Enterprise IT applications Infrastructure and Information Security teams to identify opportunities and ensure the robustness and security of database administration implementations.