Enterprise Database Engineer

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