Job Title : Senior SQL Database Specialist
Job Location : Washington, DC (Onsite)
Duration : 12+ months Contract
Position Description :
The candidate will provide all activities related to the administration of computerized databases, write SQL Server queries, and conduct backend development for the CATCH project and other TANF-related projects as needed.
They will also manage system DBs as required.
Position Duties :
- Work with the Application Software Development (ASD) Division for database-related activities on the CATCH project.
- Write SQL Server queries and conduct backend development for the CATCH project and other TANF-related projects as needed.
- Develop procedures and scripts.
- Develop, implement, and optimize stored procedures and functions using SQL for CATCH Application.
- Designs, creates, and maintains databases in a client / server environment. Develop scripts for migration of CATCH data.
- Review and interpret ongoing business report requirements to develop high-quality database solutions.
- Expert knowledge of the Structured Query Language (SQL)environment with particular emphasis on planning, analysis, design, and implementation of reports and report interfaces intended for the end user.
- Develop procedures and scripts for data migration.
- Develop, implement, and optimize stored procedures and functions using SQL.
- Review and interpret ongoing business report requirements to develop high-quality database solutions.
- Research required data for analysis.
- Assists with activities related to the design and administration of databases.
- Designs, creates, and maintains databases in a client / server environment.
- Familiarity with the use of SSIS and linked servers.
Position Responsibilities :
- Provides all activities related to the administration of computerized databases.
- Projects long-range requirements for database administration and design in conjunction with other managers in the information systems function.
- Designs, creates, and maintains databases in a client / server environment.
- Conducts quality control and auditing of databases in a client / server environment to ensure accurate and appropriate use of data.
- Advises users on access to various client / server databases.
- Designs, implements, and maintains complex databases concerning Job Control Language (JCL), access methods, access time, device allocation, validation checks, organization, protection and security, documentation, and statistical methods.
- Applies knowledge and experience with database technologies, development methodologies, and front-end (., Cognos) / back-end programming languages (.
Structured Query Language (SQL).
- Performs database programming and supports systems design.
- Additional duties include maintaining database dictionaries, overall monitoring of standards and procedures, file design and storage, and integrating systems through database design.
30+ days ago