Database Administrator/Developer
Job Description:
- Provide support for the IETSS MM program
- Analyze current and potential disparate data sources
- Participate in the validation of data quality
- Build, test, schedule, and troubleshoot extract, transform, and load (ETL) SQL Server Integration Services (SSIS) projects, solutions, and tasks built in SQL Server Data Tools (SSDT) and executed from SQL Server
- Continually measure, analyze, and improve database system performance, availability, sustainability, and security
- Discover, troubleshoot, and correct any database system issues in real time
- Create, modify, and maintain advanced SQL queries
- Review and suggest refinements to proposed database modifications
- Support all phases of solution deployment activities
- Plan and perform regular database maintenance on a periodic basis
- Be available for after-hours activities on occasion as needed
- Aid in the build of data visualizations and reports in Power BI or other IETSS accepted reporting/data visualization tools
- Assist with the extraction of requirements and assignments for proposed or impending initiatives
- Develop database objects, including but not limited to tables, functions, procedures, views, and database links in SQL Server using standard operating procedures (SOP)
- Review and pull information about IETSS processes, policies, and procedures from IETSS documentation
- Contribute to or write portions of TPQI Measures and Metrics documentation
- Support quality and process improvement methodologies to develop and continuously update the TPQI Plan
- Assist in the authoring, review, and revision of IETSS program and process documentation and artifact templates.
Requirements:
- 5 + years of experience in SQL database administration, database development, data engineering, or a similar technical role
- Relational database technologies and data normalization
- Microsoft SQL Server 2022 or higher
- Database backup and recovery
- Disaster recovery planning and execution
- Producing, reviewing, and updating system and procedural documentation
- Creating, tuning, and maintaining complex SQL queries
- Data warehouse architecture, design, and implementation
- Transact-SQL programming
- SQL Server Data Tools (SSDT)
- SQL Server Integration Services (SSIS)
- Designing and maintaining extract, transform, and load (ETL) packages, tasks, and processes
- Build and maintenance of Business intelligence (BI) and management reports
- SharePoint Online
- Microsoft Word, Excel, PowerPoint, Outlook, and Visio 2013 or higher
- TOAD for SQL Server or SSMS
- Remote Desktop Connection
- United States government-related work (e.g., Department of Defense, VA)
Benefits:
- paid leave
- options for employer sponsored group medical, dental, vision, short-term and long-term disability
- life insurance
- AD&D coverage
- legal services
- identity theft
- accident insurance
- Flexible spending account
- health saving account options
- professional growth through professional courses, certifications, and tuition reimbursement programs