SQL Server Database Administrator (DBA) in Upper Merion Township, PA at Signature Consultants

Date Posted: 7/9/2020

Job Snapshot

Job Description

SQL Server Database Administrator (DBA) Summary:

Signature Consultants is seeking a SQL Server DBA for an opportunity with a client in Upper Merion, PA. The Senior Database and iPaaS administrator is responsible for supporting, maintaining, updating and designing the data and integration infrastructure. The position is responsible for ensuring that: all data can be secured and restored based on the operational requirements and documentation; manage and maintain the Azure iPaaS services and ensure all integrations conform to the architectural standards established; maintain the ETL routines and infrastructure. The Sr. Database and iPaaS Administrator will work closely with the application development team to design new and alter existing databases, ETL and iPaaS services to meet project requirements.

Responsibilities:

  • Design and implement new database strategies to ensure all databases adhere to the recovery point and recovery time objectives defined
  • Configure, manage, maintain, administer and govern SQL Server monitoring utilities
  • Configure, manage, maintain, administer and govern iPaaS and ETL services, SQL Servers, and Azure SQL instances to perform at optimal levels and cost effectiveness
  • Support Azure Data and Data Factory services such as provisioning data storage services, ingesting streaming and batch data, transforming data, implementing security requirements, implementing data retention policies, identifying performance bottlenecks, and accessing external data sources
  • Partner with the Data Architect to plan, design, develop and maintain the overall data strategy, data architecture, data models, principles and standards
  • Provide direction on adoption of new technologies/best industry practices in the field of Azure database architecture and modeling
  • Manage outsourced vendors to service levels and outcomes
  • Participate in planning, system design and coding of new applications
  • Keep current with technology and cloud trends

Qualifications:

  • 10+ years' experience in SQL database (and server) performance tuning and troubleshooting required
  • 3+ years' experience deploying Azure DaaS solutions required
  • DBA Certification or equivalent experience as SQL Server DBA Developer/administrator, required
  • 7+ years' experience in data architecture design, modeling and ETL process modeling, preferred
  • Previous experience with MS Dynamics GP, Dynamics CRM and SharePoint OnLine, SharePoint, preferred
  • Working knowledge of Agile Software Development Lifecycle (SDLC), required
  • Experience with SQL Server, 2008 R2and above; Azure SQL; SSRS; SSIS; ETL Tools; Azure Data Factory; and BI & Data warehouse design, required
  • Experience with Power BI a plus
  • Good understand of Microsoft Azure database as a service DBaaS
  • Strong written and verbal communication skills, required

About Signature Consultants, LLC

Headquartered in Fort Lauderdale, Florida, Signature Consultants was established in 1997 with a singular focus: to provide clients and consultants with superior staffing solutions. For the ninth consecutive year, Signature was voted as one of the "Best Staffing Firms to Work For" and is now the 14th largest IT staffing firm in the United States (source: Staffing Industry Analysts). With 28 locations throughout North America, Signature annually deploys thousands of consultants to support, run, and manage their clients' technology needs. Signature offers IT staffing, consulting, managed solutions, and direct placement services. For more information on the company, please visit www.sigconsult.com. Signature Consultants is the parent company to Hunter Hollis and Madison Gunn.

CHECK OUT OUR SIMILAR JOBS

  1. Developer Jobs
  2. DBA Jobs