Job Title: Database Administrator (812742)

Location: Dauphin County

Client: Commonwealth of PA

Duration: 08 Months

Note: This is a 100% remote role, Manager will work details for equipment pick up in interviews & after selection.

Key Responsibilities

This position is responsible for advanced technical work in all phases of database administration support; development activities (support the application development lifecycle, planning, design, development, implementation, data migration, quality assurance, data cleanup, and data administration) as well as database operations activities (database administration, database security, assuring availability, server and database monitoring, performance monitoring, SQL software installation and configuration, and Service Pack installations).
Provides Operations support for SQL Database and Database Server administration support for critical production systems.
Ensures overall health and availability and quality of services
Perform Health Checks to review the performance of databases to identify and provide recommendations to enhance performance of databases.
Performs migration and upgrade of SQL Databases from legacy server\SQL Version to new server\SQL Version.
Performs data migration by designing programs to optimally extract, cleanse, transform and load data between data sources as part of data migration and data validation support.
Deploying SQL database solutions within Azure
Securing Azure SQL resources and data Provides Database Design support.
Defines, develops, and creates databases by assessing requirements.
Meet with developers and vendors to ascertain requirements and to provide consulting assistance to determine the appropriate database configurations.
Deploy and maintain database schema changes across test and production environments.
Provide technical support for the PSP Data Warehouse, Data Marts, and Power BI environments in collaboration with the Lead Power BI Administrator.
Deploy, configure, secure, backup, and maintain Azure SQL database solutions.
Integrate Azure SQL resources with other Azure services to support enterprise applications and data solutions.
Monitor, troubleshoot, and optimize Azure SQL and SQL Server Database performance and availability.
Support the migration of on-premises SQL Server databases to Azure SQL.
Design, develop, and maintain logical and physical database models based on business and technical requirements. Review and validate data models and data dictionaries to ensure compliance with organizational standards.
Develop and maintain database structures, including tables, relationships, and normalization, to ensure data integrity, efficiency, and minimize redundancy.
Collaborate with developers, business stakeholders, and vendors to gather requirements and recommend appropriate database architectures and configurations.
Coordinate database backup and restore requests with the backup administration team.

Required Skills:

SQL Server Database Administration experience
Worked in Database Administration on Production Servers
Data Analytics experience
Azure Database Administration experience
Data Warehouse experience
Excellent Communication Skills
Provides high quality and professional customer service
Power BI Administration
Business systems analysis and design experience

If you are: bright, motivated, skilled, a difference-maker, able to get things done, work with minimum direction, enthusiastic, a thinker, able to juggle and multi-task, communicate effectively, and lead, then we would like to hear from you. We need exceptionally capable people for this role for our client, so get back to us and tell us why

you think you are a fit.

About Us:

Since 2000, Tri-Force Consulting Services () has been an MBE/SDB certified IT Consulting firm in the Philadelphia region. Tri-Force specialises in IT staffing, software development (web and mobile apps), systems integration, data analytics, system automation, cybersecurity, and cloud technology solutions for government and commercial clients. Tri-Force works with clients to overcome obstacles such as increasing productivity, increasing efficiencies through automation, and lowering costs. Our clients benefit from our three distinguishing core values: integrity, diligence, and technological excellence. Tri-Force is a six-time winner among the fastest-growing companies in Philadelphia and a four-time winner on the Inc. 5000 list of the nation's fastest-growing companies.

Database Administrator

Key skills

About this role