SQL Database Administrator

SQL Database Administrator Requisition ID : 788750 Work onsite: OIC location (William Green Building 8th floor, 30 West Spring Street, Columbus, Ohio).Interviews will be onsite.

Job Description:

The ideal candidate will have the skills specified below: 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. Experience with IBM DB2 database will be desired Day-to-Day responsibilities include, but are not limited to: 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.

REQUIRED:

1. Experience administering and tuning high-traffic production databases (e.g., SQL Server) 10 Years
2. Expert-level knowledge of SQL, DDL, DML, and advanced tuning techniques (indexing, partitioning, materialized views, execution plan analysis 10 Years
3. Experience with database monitoring tools (e.g., Prometheus, Grafana, OEM, New Relic) and building custom alerting thresholds 10 Years
4. Proficiency in relational data modeling (3rd Normal Form) and NoSQL modeling concepts 10 Years
5. Hands-on, professional development experience with Java 11+ (or higher) in the Windows environment. 5 Years
6. Experience with Java Persistence API (JPA), SQL, RESTful web services and JUnit 5 Years
7. Experience designing and implementing RESTful APIs for data delivery 5 Years
8. In-depth understanding of Object-Relational Mapping (ORM) and its performance implications, including cache management, lazy vs. eager 5 Years
9. Experience working IBM DB2 database