CITIZENSHIP
Be a citizen of the U.S. or legal permanent resident
The candidate must be a US citizen or Legal permanent resident. Also this is a 1099 Contract position and you must be residing in the USA.
Job Description:
Azure SQL Server DBA / SSRS / SSIS
Primary Responsibilities:
Below are the duties of the DBA but not limited to the following tasks:
· Working with other teams to consolidate database instances and storage using capacity and performance analysis tools to identify underutilized instances, duplicate copies of data and identify associated server, network and storage resources that can be “right sized”
· Support the database engineering team in integrating, implementing, and operating the Database systems (SQL Server 2008 SSRS, SSIS and higher versions of SQL Server and Polybase) across the entire enterprise and with cloud service providers to support 24x7x365 availability.
· Conduct problem root cause analysis and isolate system problems utilizing diagnostic and system management tools (i.e. system dumps and system/component traces, monitoring tools, vendor problem data bases).
· Maintain security hardened baseline configurations and deploy security (patches), software maintenance (patches) and new software releases and supporting products infrastructure as directed by the system owner, policy, or the Cybersecurity Directorate.
· Support the engineering, integration, implementation, and operation of a virtualization strategy to include Database server consolidation, storage consolidation, and automation. Automation includes seamless Database provisioning, and non-disruptive workflow/application/data migrations.
· Maintain up-to-date documentation of all procedures, infrastructure diagrams, system configuration and baseline standards, implementation plans, system back out plans, system recovery plans, maintenance plans, system upgrades, and all system changes.
· Support resolution of incidents and execution of approved change requests.
· Design and implement automated responses to system issues (e.g., automatic failover, resource allocation adjustments).
Required Skills:
· Azure SQL Server Certified
· Strong knowledge of Azure
· Performed database consolidation projects
· Deep understanding of SSRS and SSIS
· Deep understanding of Database / Data security in Azure
· Deep understanding of PKI
· Strong experience in database performance monitoring and tuning
· Deep understanding of Azure SQL Database pricing and deployment models
· Deep understanding of data models (logical and physical)
· Strong in developing database design, architecture models etc. artifacts
· All other standard SQL Server DBA and SQL developer qualifications
· 7-10 years of experience and a B.S. degree. Bachelor of Science (BS) can be substituted with an additional 4 years of related experience.
· 7+ years of experience as SQL Server Database Administrator for 24x7 operations
· 7+ years of experience with database migrations involving SQL Server
· 7+ years of experience with SQL scripting
· 7+ years of experience managing Microsoft SQL servers in VMWare and cloud/virtual environment.
· Familiarity with .net framework.
Good to Have -
· Knowledge of Power BI
Job Type: Full-time
Job Type: Full-time
Pay: From $65.00 per hour
Schedule:
• 8 hour shift
Application Question(s):
• Are you able to do the Public Trust?
• Are you a US citizen or Permanent Resident
• Do you have SSIS Development and optimization experience
Work Location: Remote
