Senior Database Developer (SQL)

Softtek Government Solutions is currently seeking a Sr. Database Developer to join one of our Agile teams in support of the development, enhancement, administration, and maintenance of various data-centric custom software applications for a government agency. In this role, you will design and develop data models, data management processes, reports, as well as perform database administration and provide expert level technical support to other developers focused on Microsoft Technologies (SQL Server).

Responsibilities

Relational Database Design:

• 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

Database Administration:

• Perform monitoring of database instances, high availability (HA) nodes & clusters

• Schedule automate jobs / procedures to conduct database backups and monitor database health and disk space

• Implement security controls / privileges for database servers, databases, objects, and users
• Implement and manage database backup and disaster recovery procedures (e.g., restoring databases)
• Plan and execute database upgrades
• Apply software patches

Database Source Control:

• Maintain and version control all database objects (e.g., tables, views, stored procedures, scripts) using a robust source control system (e.g., Git, SVN)
• Implement and adhere to best practices for database change management, including code reviews, unit testing, and deployment procedures

Data Management and ETL:

• Manage data and schema migrations

• Perform data Integrations and data migration processes
• Developing extract, transform, and load (ETL) procedures in T-SQL language

• Extract data into text file formats such as CSV, JSON, XML, TXT, etc.

Technical Support:

• Provide database support to software application developers

• Provide support during database/application outages
• Participate in incident bridge/conference calls
• Perform incident handling to restore database functionality as quickly as possible

Qualifications

Required Education:

• Bachelor's degree in information technology, Computer Science, or related discipline

Required Experience and Skills:

• 4 years prior work experience in a similar role

• 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
• U.S. Citizenship

Desired Qualifications:

• Strong verbal and written English communication skills

• Experience working as part of an Agile scrum team
• Managing tickets in JIRA or similar agile project management tool
• Editing Confluence or similar wiki pages
• Microsoft Office

Required Clearance:

• Must be eligible for a Top Secret (TS) clearance.

• Candidate is not required to hold active clearance at time of hire.

Location

• Primarily remote with occasional work location at customer office in Washington, DC
• Candidate must reside within a reasonable commuting distance of Washington, DC

About Softtek Government Solutions:

Softtek Government Solutions is a professional services firm focused on addressing our nation's most complex threats and challenges. As a small business we're committed to supporting our clients' missions with services delivered by our diverse and experienced staff. With expertise in cybersecurity, emergency preparedness, and public health, our experience base spans federal, state, and local governments, as well as private sector entities.

Softtek Government Solutions encourages collaborative communication and ongoing learning. Some of our benefits include:

• Extensive training programs
• Gym membership reimbursement
• Education reimbursement
• Technology benefits
• Commuter benefits
• Generous paid time off and much more!

Softtek Government Solutions is an Equal Opportunity Employer (EOE)