JPI is seeking a Database Administrator (DBA) with a strong development background and experience building relational databases. The DBA will design, implement, and manage databases and data delivery systems for a DHS client while ensuring that all database code meets standards for readability, reliability, and performance. The DBA will balance technical leadership with hands-on development and implementation to initiate, plan, and execute efficient database and analytics solutions. Ideal candidates will be self-starters, highly independent and comfortable in agile production environments. Position is open to both W2 and 1099 candidates.
Responsibilities
- Develop conceptual and logical data models for DHS client, mapping the structure of the current database assets.
- Collect and map user requirements to existing Access Databases
- Clean up and remove database tool components that do not trace back to program user requirements and needs.
- Decompose master databases into coherent functional smaller databases to reduce the overall load demands on the databases
- Develop a long-term database roadmap to help modernize processes and database assets to ensure long-term viability of all Program data processing needs.
- Develop user guides for existing and new databases
- Develop, implement and maintain new database solutions tailored to DHS client needs
- Full life cycle support of client's databases.
- Responsible for database backups, design, development, testing, and performance tuning.
- Responsible for the design and implementation of analytics solutions as needed
- Provide regular error reporting and perform regular data integrity checks
- Run regular reports and create client facing deliverables as needed
- Serve as SME when needed?
- Bachelor's degree is required. Master's degree or equivalent experience preferred
- Expert Knowledge of database programming and query troubleshooting.
- 8+ years of relevant experience
- 5+ years of experience with MS SharePoint
- 2+ years of experience with MS Access
- 2+ years of experience with SQL
- 2+ years of experience with VBA
- Experience in Database Architecture
- Knowledge of Python or R is a plus
- Strong analytical and troubleshooting skills for complex database performance.
- Strong knowledge of database upgrade/migrations.
- Able to understand and meet needs of end users.
- Good written and oral communication and soft skills.
- Able to work with multiple projects in a dynamic, fast paced and often changing environment.?
JPI is committed to creating a diverse environment and is proud to be an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability, age, or veteran status.
United States
