Senior SQL Server Database Admin

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.