Senior Database Developer
Emprise Corporation · Chesapeake, VA · 2 wk ago
On-siteInformation TechnologyFull-time
Key Responsibilities
- Design, develop, and maintain database views, stored procedures, and functions using advanced ANSI SQL.
- Support and enhance the existing database schema to meet evolving business needs.
- Implement and manage transactional control to ensure data consistency and integrity.
- Collaborate with software engineers, analysts, and business stakeholders to gather requirements and deliver SQL solutions.
- Perform query tuning and optimization for scalability and performance.
- Ensure proper documentation of database objects, procedures, and standards.
- Provide input into database design improvements and schema evolution strategies.
- Support operational stability by participating in database reviews, testing, and monitoring.
Requirements
- Advanced expertise in ANSI SQL with demonstrated ability to write complex procedures, functions, and queries.
- Solid understanding of transaction control (BEGIN, COMMIT, ROLLBACK) and concurrency management.
- Strong knowledge of database development best practices including normalization, indexing, and data consistency.
- Experience with one or more enterprise RDBMS platforms (e.g., SQL Anywhere, IBM DB2, MariaDB, SQL Server, MySQL).
- Excellent problem-solving and debugging skills with attention to detail.
- Strong communication and collaboration abilities in a team environment.
- Bachelor’s degree in Computer Science, Information Systems, or equivalent professional experience.
- Must be able to obtain and maintain a DOD Security Clearance.
Preferred Qualifications
- Experience with database performance optimization and diagnostic tools.
- Familiarity with replication technologies and high availability database environments.
- Exposure to database design, data modeling, and ETL processes.
- Knowledge of DevOps practices for database deployment and version control.
- SQLite experience is a plus.