Onsite
Description
DSI is searching for a skilled Database Administrator to manage and optimize our critical Oracle and PostgreSQL database environments, including AWS RDS PostgreSQL and Oracle RAC. The ideal candidate will be responsible for data analysis, database administration, maintenance, and performance tuning.
This role requires a strong understanding of database principles, excellent problem-solving abilities, and the capacity to work both independently and collaboratively. If you are passionate about database management and eager to contribute to a dynamic team, we encourage you to apply.
Responsibilities
Managing and maintaining Oracle databases, including Oracle Real Application Clusters (RAC).
Utilizing AWS CloudWatch to monitor database health and performance, and AWS CloudTrail for auditing and security purposes.
Implementing and managing cloud concepts such as scalability, elasticity, on-demand provisioning, and cost optimization.
Supporting the application system development life cycle methodologies.
Creating and configuring RDS resources using CloudFormation templates for infrastructure-as-code.
Developing and implementing database backup and recovery strategies.
Defining and implementing database standards.
Writing and maintaining scripts in Shell, SQL, PL/SQL, and Python for various database tasks.
Configuring RDS for high availability (HA) and disaster recovery using multi-AZ deployments and backups.
Performing database performance tuning and monitoring.
Scheduling and monitoring data warehousing processes.
Participating in software release management processes.
Communicating effectively with team members and stakeholders, demonstrating excellent interpersonal and collaboration skills.
Managing time effectively and prioritizing tasks to meet deadlines.
Diagnosing and resolving database errors and performance issues using logs, metrics, and AWS documentation.
Applying logical data modeling techniques.
Authoring shell scripts to perform backup, restore, and monitoring tasks.
Designing, installing, and converting databases.
Ensuring database backup and recovery procedures, access security, database integrity, physical data storage design, and data storage management.
Requirements
7 years experience with Enterprise Database Administration required.
Bachelor's degree in Computer Science or related field with advanced study preferred. Oracle, PostgreSQL, Oracle RAC, SQL, MS SQL Server, Docker, AIX, AWS RDS, Shell, Python, PL/SQL Required Relevant certifications in Oracle and/or PostgreSQL administration highly desired.
Experience With Other Cloud-based Database Services Highly Desired.
Knowledge of data warehousing concepts and technologies highly desired.
About Diversified Systems
Founded in 1990, Diversified Systems is an award-winning Technology Services corporation providing all levels of IT project consulting services nationwide. DSI is headquartered in Columbus, Ohio with regional offices in the American Midwest and East Coast. We offer our consultants a number of flexible and competitive compensation benefit packages.
Diversified Systems is committed to the principles of equal employment. We are committed to complying with all federal, state, and local laws providing equal employment opportunities, and all other employment laws and regulations.
Diversity, Equity and Inclusion
DSI values authenticity and is committed to making sure our employees and partners are valued and respected. At DSI, we believe building a diverse culture is important because we know when people work together, we can achieve better results as a team. DSI realizes that everyone comes from various backgrounds. We celebrate these differences because our employees are our greatest asset as we strive to best meet the needs of those we serve. As part of our ongoing efforts, DSI is focused on advancing equality, diversity, and inclusion by setting high standards to continually evolve our culture. This includes but is not limited to recruiting, community involvement, client delivery, and career development.