Senior Database Management Specialist
Role details
Job location
Tech stack
Job description
Technology Consultants Inc is looking for a talented and driven Senior Database Management Specialist to join our team in Ashburn, VA. This is an exciting opportunity to take ownership of critical data infrastructure in a fast-paced, innovative consulting environment. If you're passionate about data integrity, performance, and scalability, we want to hear from you! Clearance: Active Public Trust in DHS or a component of DHS What You'll Be Doing The Database Developer will work with a team of database developers and database administrators to support an active program of application development - creating new structures, updating existing ones and managing data within large, complex databases. This is a great opportunity to learn a new domain and a new skillset in a dynamic environment.
Requirements
- Bachelor's degree plus 5+ years in database development roles
- Experience in data profiling, cleansing, reporting, data staging, ETL jobs
- Strong experience creating complex SQL in complex data environments
- Strong experience troubleshooting, tuning SQL and writing performance queries
- Experience in writing DDL, DML and DCL
- Hands-on experience with PostgreSQL database development
- Experience writing Python scripts
- Experience with Git/version control
- AWS experience including data migration, validation, data pipelines, CloudWatch, Kibana and Dynatrace
- Ability to learn new tools quickly as needed to provide new ideas for solving problems
- Ability and desire to work with other program staff and customers to reach design decisions within given constraints
- Excellent diplomacy and communication skills with both clients and technical staff
Preferred Skills and Experience:
- Experience working with federal government clients
- Experience with Oracle/DB2/SQLServer/MySQl/Terradata
- Experience with Databricks, PySpark, Liquibase, DMS
- Experience in database administration
- Experience with Agile methodology and use of Jira for tracking
- Must be willing to learn DB2 if not already a skill set
Benefits & conditions
- 401(k)
- Health insurance
- Paid time off
- Dental insurance
- Vision insurance