Softtek Government Solutions is seeking a Database Developer to support a government agency in the development, enhancement, administration, and maintenance of various data-centric custom software applications.
Requirements
- Hands-on database design, development, and administration experience
- Expert level T-SQL and SQL skills
- Microsoft SQL Server 2022 & 2019.
- SQL Server Management Studio (SSMS)
- CompTIA Security+ Certification or willingness to pass exam within 45 days of hire
Responsibilities
- Design and implement robust and scalable relational databases, adhering to industry best practices for data normalization and database design principles
- Define and implement data models, including entities, attributes, relationships, and constraints (e.g., primary keys, foreign keys, unique constraints)
- Create and maintain database tables, views, and indexes to optimize data retrieval and query performance
- Develop and implement complex stored procedures, functions, and triggers to automate data manipulation tasks, improve data integrity, and enhance application functionality
- Perform monitoring of database instances, high availability (HA) nodes & clusters
- Implement security controls / privileges for database servers, databases, objects, and users
- Developing extract, transform, and load (ETL) procedures in T-SQL language
Other
- 4 years prior work experience in a similar role
- U.S. Citizenship
- Must be eligible for a Top Secret (TS) clearance.
- Candidate is not required to hold active clearance at time of hire.
- Primarily remote with occasional work location at customer office in Washington, DC
