What are the responsibilities and job description for the Database Administrator position at Stellar Professionals LLC?
Job Details
Location & Work Arrangement
- City, State: Columbus, Ohio
- Work Arrangement: Onsite (Required to work onsite at the William Green Building).
- Contract: This is a Contract position.
- Mode of Interview: In Person.
Key Responsibilities and Technical Expertise
The ideal candidate will bridge the gap between application development and core database administration, with significant experience in performance engineering.
1. Database Administration & Performance Engineering (10 Years Required)
- Performance Tuning: Actively analyze, tune, and optimize slow SQL queries and stored procedures impacting application performance.
- Expert-level knowledge of SQL, DDL, DML, and advanced tuning techniques (indexing, partitioning, execution plan analysis).
- Operations: Responsible for database backup and recovery procedures, access security, database integrity, physical data storage design, and data storage management.
- Monitoring: Monitor database performance and space requirements. Experience with database monitoring tools (e.g., Prometheus, Grafana, OEM) and building custom alerting thresholds.
- Design & Upgrades: Highly skilled at database design, installations, and conversions (specifically SQL Server). Evaluate and perform database upgrades.
- Data Modeling: Proficiency in relational data modeling (3rd Normal Form) and NoSQL modeling concepts. Skilled data dictionary analysis and design.
2. Java Development & Application Integration (5 Years Required)
- Data Access Layer: Design, implement, and unit-test high-performance data access layers (JPA/DAO/JDBC) and data-centric microservices using Java (11 or higher) in the Windows environment.
- API Development: Experience designing, developing, and consuming RESTful APIs for seamless integration and efficient data delivery.
- ORM: In-depth understanding of Object-Relational Mapping (ORM) (e.g., JPA/Hibernate) and its performance implications (e.g., cache management, lazy vs. eager loading).
- Code Quality: Perform rigorous code reviews focusing on ORM usage, transaction management, and efficient data retrieval to prevent database anti-patterns.
- Automation: Author scripts (in Java or scripting languages) to automate repetitive DBA tasks and enhance operational monitoring.
3. Support and Documentation
- SDLC: Experience and knowledge in supporting the application system development life cycle.
- Documentation: Document data flows, API specifications, and database operational procedures.
- Collaboration: Implement best practices for efficient data access and database interaction within the Java/Angular environment. Identify and track issues, risks, and action items.
- Desired Plus: Experience working with IBM DB2 database is highly desired.
Required Technical Skills Summary
| Skill Area | Required Experience | Key Technologies/Concepts |
| Database Expertise | 10 Years | SQL Server (High Traffic Production), SQL (Expert DDL/DML), Performance Tuning, Backup/Recovery, Data Modeling. |
| Monitoring | 10 Years | Database Monitoring Tools (Prometheus, Grafana, OEM), Custom Alerting. |
| Java/Integration | 5 Years | Java 11 , JPA (Hibernate/ORM), RESTful web services, JUnit, Code Review. |
| Soft Skills | N/A | Strong written/spoken communication, Ability to work in a team environment, Execute responsibilities with little direct supervision. |