SQL Sr. Database Developer/Consultant-1099

Aveshka Inc•Washington, DC

8h•Hybrid

About The Position

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, extract transform load (ETL) procedures, business intelligence reports, as well as perform database administration and provide expert level technical support to other developers focused on both PostgreSQL and Microsoft SQL Server.

Requirements

Bachelor’s degree in information technology, Computer Science, or related discipline
4 years prior work experience in a similar role
Experience programming in both T-SQL and PL/ Postgres SQL
Hands-on database design, development, and administration experience
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
Must be eligible for a Top Secret (TS) clearance.
Candidate is not required to hold active clearance at time of hire.

Nice To Haves

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

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
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
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
Manage data and schema migrations
Perform data Integrations and data migration processes
Developing extract, transform, and load (ETL) procedures in T-SQL and/or PL/pgSQL language
Extract data into text file formats such as CSV, JSON, XML, TXT, etc.
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