Job Description
Title: Senior SQL Server and Azure Database Administrator
Location: Harrisburg, PA (Mostly remote)
Duration: 8+ Months
Type: Contract
Interview: Preferably in-person interview
***Client would prefer candidates local to the Harrisburg, PA Area.***
Position will primarily be remote; however, candidate may have to report on-site for fingerprinting and picking up equipment.
Job description:
Required Skills:
Location: Harrisburg, PA (Mostly remote)
Duration: 8+ Months
Type: Contract
Interview: Preferably in-person interview
***Client would prefer candidates local to the Harrisburg, PA Area.***
Position will primarily be remote; however, candidate may have to report on-site for fingerprinting and picking up equipment.
Job description:
- 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
- Microsoft SQL (HA / Always On)
Numbers & Facts
| Location | Harrisburg, PA |
| Industry | Computer/IT Services |
| Company Size | 20 to 49 employees |
| Year Founded | 2002 |
| Website | http://crescensinc.com/ |
About Company
Crescens Inc. is an industry leader in providing IT staffing services and tailored workforce solutions to meet the demanding expectations and distinctive needs of clients across the United States and Canada. We have grown tremendously in the past years and have been applauded by our clients for the quality of workforce and the quick turnaround time. We have evolved from good service to great service and all management plans are geared towards quality.
Our vision is to be the best in Talent Acquisition and strive for excellence consistently by focusing on four performance dimensions; Quality, Efficiency, Cost and Risk. A satisfied client and candidate are the backbone to our continued success. Headquartered in New Jersey, we are a team with unique expertise to deliver exceptional results to our clients by setting benchmarks and establishing best practices.
Skills
- Business Modelunmatched
- Business Solutionsunmatched
- Communication Skillsunmatched
- Consultingunmatched
- Customer Support/Serviceunmatched
- Data Administrationunmatched
- Data Analysisunmatched
- Data Cleaningunmatched
- Data Martunmatched
- Data Migrationunmatched
- Data Modelingunmatched
- Data Qualityunmatched
- Data Recoveryunmatched
- Data Warehousingunmatched
- Database Administrationunmatched
- Database Analysisunmatched
- Database Architectureunmatched
- Database Backupunmatched
- Database Designunmatched
- Database Programmingunmatched
- Database Technologyunmatched
- Design Servicesunmatched
- Enterprise Applicationsunmatched
- Identify Issuesunmatched
- Information/Data Security (InfoSec)unmatched
- Maintain Complianceunmatched
- Microsoft SQL Serverunmatched
- Microsoft SQL Server DBA (Database Administration)unmatched
- Microsoft Windows Azureunmatched
- Operational Supportunmatched
- Performance Analysisunmatched
- Power BIunmatched
- Production Systemsunmatched
- QoS (Quality of Service)unmatched
- Quality Assuranceunmatched
- Regulatory Complianceunmatched
- Requirements Managementunmatched
- SQL (Structured Query Language)unmatched
- SQL Databasesunmatched
- Server Supportunmatched
- Software Administrationunmatched
- Software Configuration Managementunmatched
- Software Development Lifecycle (SDLC)unmatched
- Software Installationunmatched
- Systems Administration/Managementunmatched
- Systems Analysisunmatched
- Team Playerunmatched
- Technical Supportunmatched
Level up your application
Professional resume templates
Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.
Free resume templatesFree resume builder
Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.
Free resume builder