Senior Database Engineer

One of our clients in the government domain is seeking a Senior Database Engineer. This position will support the Division of Information Technology at the Ohio Industrial Commission. Senior Database Engineer On-Site In-Person Interview William Green Building, 8th floor, 30 West Spring Street, Columbus, Ohio Long Term Contract Responsibilities: 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. Key Skills: Highly skilled at database design, installations, and conversions, specifically with SQL Server databases. 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. Responsible for 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. Responsible for data dictionary backup and recovery. Responsible for the 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. Skills Required: 10 years of Experience administering and tuning high-traffic production databases (e.g., SQL Server) 10 years of Expert-level knowledge of SQL, DDL, DML, and advanced tuning techniques (indexing, partitioning, materialized views, execution plan analysis 10 years of Experience with database monitoring tools (e.g., Prometheus, Grafana, OEM, New Relic) and building custom alerting thresholds 10 years of Proficiency in relational data modeling (3rd Normal Form) and NoSQL modeling concepts 5 years of Hands-on, professional development experience with Java 11+ (or higher) in the Windows environment. 5 years of Experience with Java Persistence API (JPA), SQL, RESTful web services and JUnit 5 years of Experience designing and implementing RESTful APIs for data delivery 5 years of In-depth understanding of Object-Relational Mapping (ORM) and its performance implications, including cache management, lazy vs. eager Highly Desired Skill: Experience working with IBM DB2 database