Senior SQL Server Database Admin

Dice is the leading career destination for tech experts at every stage of their careers. Our client, Kodi Inc, is seeking the following. Apply via Dice today!

Seeking a Senior SQL Server Database Admin experience in database design, installations, and conversions, specifically with SQL Server databases, JAVA, JPA Modelling , Tuning and IBM DB2 database. Interview: In-Person

Interview: In-Person

Location: Columbus, OH

Posting: 788750

Work: ON-SITE

Role and Experience

• 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
• 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.