Diligent Consulting - Washington, DC
posted 2 months ago
The Jr Database Admin position at Diligent Consulting Inc involves a comprehensive range of responsibilities centered around the installation, configuration, and management of various database systems. The successful candidate will work with databases such as Sybase ASE & Replication, Oracle, SQL Server, PostgreSQL, and MongoDB. A key aspect of this role is to monitor and optimize database performance using advanced tools like AWR, ADDM, Explain Plan, and SQL Trace. The candidate will also be responsible for developing and implementing robust database backup and recovery strategies, ensuring that data is secure and recoverable in case of any failures. In addition to performance monitoring, the role includes performing database migrations, upgrades, and patch management to keep systems up to date and secure. Automation of routine database administration tasks through shell scripting is also a critical responsibility, aimed at improving efficiency and reducing manual workload. The candidate will collaborate closely with development teams to optimize database queries and design, ensuring that applications run smoothly and efficiently. The position also requires managing cloud-based database services on AWS, including RDS, EC2, S3, and Redshift. The candidate will utilize various database management tools such as DBArtisan, SQL Server Management Studio, pgAdmin, and MongoDB Compass to perform their duties effectively. Troubleshooting and resolving database-related issues promptly is essential, as is providing technical support and guidance to other team members as needed. This role is ideal for someone with a strong background in database administration and a passion for optimizing database performance and security.