Database Administrator

Join to apply for the Database Administrator role at Diversified

Onsite

DSI is searching for a Database Administrator who will support a Division of Information Technology and will be highly skilled at database design, installations, and conversions, specifically with SQL Server databases.

• Performance Engineering:
  Actively analyze, tune, and optimize the slow SQL queries and stored procedures impacting application performance.
• Java Development:
  Design, implement, and unit-test high-performance data access layers (JPA/DAO/JDBC) and data-centric microservices using Java.
• Code Review:
  Perform rigorous code reviews focusing on ORM usage (JPA/Hibernate), transaction management, and efficient data retrieval to prevent common database anti-patterns (like N+1 queries).
• Support Ongoing Projects:
  Monitor, diagnose, and quickly resolve critical issues related to database locking, deadlocks, and high resource utilization.
• Schema Design:
  Collaborate with application developers to design and document optimal physical and logical database schemas (DDL) for new features.
• Monitoring & Health:
  Review daily database health reports, manage routine maintenance (e.g., statistics updates), and ensure replication health.
• Automation:
  Develop and maintain custom tooling or scripts (often in Java or scripting languages) to automate repetitive DBA tasks and enhance operational monitoring.
• Deployment & CI/CD:
  Ensure that database migrations and application changes are safely deployed through CI/CD pipelines following governance and testing standards.

• Document data flows, API specifications, and database operational procedures.
• Implement best practices for efficient data access, transactions, and database interaction within a Java (Back End) and Angular (Front End) environment.
• Skilled data dictionary analysis and design, and data model analysis and design.
• Database backup and recovery procedures, access security and database integrity, physical data storage design, and data storage management.
• Engage in ongoing process improvement.
• Skilled data dictionary analysis and design, and data model analysis and design.
• Experience and knowledge in supporting the application system development life cycle.
• Data dictionary backup and recovery.
• Definition of standards of data dictionaries.
• Perform performance tuning.
• Monitor database performance and space requirements.
• Schedule and monitor end-of-day data warehousing jobs.
• Evaluate and perform database upgrades.
• Ability to work in a team environment.
• Strong communication skills, both written and spoken.
• Logical data modeling techniques.
• Knowledgeable in data analysis and database management techniques.
• Execution of all responsibilities with little direct supervision of the Team Lead.
• Author scripts to perform backup, restore, and monitoring tasks.
• Identify and track issues, risks, and action items.
• Experience in Java solution development in the Windows environment.
• Experience with Java Persistence API (JPA), SQL, RESTful web services, and JUnit.
• Experience designing, developing, and consuming RESTful APIs for seamless integration.
• Strong experience with SQL Server Database.
• Experience with IBM DB2 database will be desired.

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.

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.

Seniority level:
Mid-Senior level

Employment type:

Full-time

Job function:
Other

Industries: IT Services and IT Consulting