SQL Cloud DBA

Our client, a Medical Center facility under the aegis of a California Public Ivy university and one of largest health delivery systems in California, seeks an accomplished SQL Server DBA.

__________________________________________

NOTE- THIS IS LARGELY REMOTE ROLE & ONLY W2 CANDIDATES/NO C2C/1099

*** Candidate must be authorized to work in USA without requiring sponsorship ***

Position: SQL Server DBA (Job Id – 2565570)

Location: San Francisco CA 94104 (Hybrid 1-2 days onsite every 6 months possible)

Duration: 6 Months + Possible Extension

______________________________________________________________________

Notes:

• Standard hours: Mon – Fri, 8:00am – 5:00pm Pacific Time.
• Largely remote but 1-2 days onsite every 6 months possible.

Job Description:

• Level 3 Systems Administrator.
• This key position will be integral in providing data warehouse services to support all areas of our mission including strategy, operations, research, patient access, and overall optimization.
• This position is responsible for the maintenance and growth of our data warehouse technical stack.
• Its work includes consulting with developers for smooth deployments, satisfying ETL deployments with established governed practices, working with other teams in the department to provision access appropriately to the warehouse, and being a general technical resource available to automate key functions.
• The position plays a critical role in ensuring data is ingested and curated into our data warehouse on schedule and that developers and users are made aware of the statuses of their data flows and engaged to address issues.
• In addition to these duties, the position is required to perform any other tasks assigned to support the department’s function.
• A data warehouse operations analyst is responsible for creating databases, user provisioning, and supporting data engineers to meet company’s data and analytics needs.
• Provisions users in Microsoft SQL Server.
• Creates new databases in SQL Server.
• Creates new schemas in SQL Server with appropriate attention to data security.
• Works with ETL developers to host SSIS packages on Integration Services Server.
• Ensures all EIA best practices for ETL packages are adhered to within developer packages.
• Troubleshoots ETL errors with developers.
• Performs day to day monitoring of backups/CPU/storage growth.
• Manages replication tool (DMS) to create/sync and maintain new assets.
• Uses and supports all company service tools, including ServiceNow, PagerDuty, portfolio task management, and technical tools SSIS, SSMS, and GitHub.
• Maintains thorough and detailed documentation around deployment practices, user provisioning, and database management.
• Is capable of creating and maintaining ETL packages using Microsoft SQL Server Integration Services.
• Participates in project planning, including scoping backlogs and determining estimates.
• Assumes on-call duties to support the operation of reporting and analytics systems.
• Maintains appropriate business domain knowledge in healthcare, education, research, finance, or business administration.
• 50% (Developer Support): Works with developers to deploy Extract, Transform, Load (ETL) jobs in our enterprise data warehouse from Development to Test and from Test to Production environments.Acts as an MS Integration Services administrator, ensuring ETL standards and guidelines are enforced. Troubleshoots issues with developers during deployment. Administer data replication tools e.g., AWS Data Migration Service (DMS) to create/sync and maintain new assets in the enterprise data warehouse.
• 25% (Systems Administration): Responsible for Database administration duties, day to day monitoring of backups/CPU/storage growth. Capacity planning and forecasting the future growth in AWS and on-premises systems. Automates administration tasks. Coordinates with company’s Secure Enterprise Cloud (SEC) team to incorporate services from Amazon Web Services into the suite of tools available for SEC hosted environments at company.
• 25% (User Support and Team Collaboration): User provisioning and maintaining the ServiceNow queue of access requests. Creates new databases and implements security in accordance with data compliance standards. Designs solutions which are scalable. Implements frameworks which are flexible to adapt for future changes.

Qualifications:

• Minimum 3 years as a Microsoft SQL Server Database Administrator.
• At least 3 years writing T-SQL. Experienced in writing complex SQL queries and stored procedures. Understanding of query performance tuning.
• The ideal candidate knows AWS networking and server technologies but is also an Integration Services Administrator (ETL Administrator) and Database Administrator. Microsoft SQL Server or AWS certifications would be welcome, but not required.
• Minimum of 3 years using at least one ETL tool such as Microsoft SQL Server Integration Services (SSIS), AWS Glue, Microsoft Azure Data Factory, IBM Infosphere DataStage, or any ETL applications.
• Minimum 3 years administering ETL jobs in Microsoft Integration Services.
• Demonstrated familiarity with AWS tools and terms (S3, EC2, EBS, DMS).
• Possesses working knowledge of networking and firewalls.
• Detail oriented technical and process documentation writing and maintenance.
• Experience developing and executing complex test plans.
• Must be able to work with multiple RDBMS environments such as Oracle, SQL Server, MySQL, and so on.
• Demonstrated ability to automate functions in AWS (e.g., Lambda functions, PowerShell scripts).
• Capable of designing and developing data extraction, integration, and transformation solutions.
• Demonstrate the ability to create, code, and test ETL routines.
• Possess an understanding of the principles of effective ETL design.

Preferred:

• Understanding of advanced statistical analytics, machine learning, and data science principles.
• Experience with cloud computing and technologies.
• Experience in Agile working environment is desired.
• Experience in one programming language such as Python, R, Java, C++, C+, etc.
• Advanced knowledge of secure software development.
• Highly advanced skills associated with software specification, design, modification, implementation, and deployment of large-scale scope.
• Excellent project leadership and management skills.
• Able to resolve and improve performance issues.
• Experience in working with other technical and business teams to carry out system performance tuning.
• Experience with clinical and healthcare administration data.
• Experience with healthcare, education, research, financial, or business administrative data.
• Experience with the Epic electronic health record databases including Clarity and Caboodle.

______________________________________________________________

Bhupesh Khurana

Lead Technical Recruiter

Email – bkhurana@ameritconsulting.com

Company Overview:

Amerit Consulting is an extremely fast-growing staffing and consulting firm. Amerit Consulting was founded in 2002 to provide consulting, temporary staffing, direct hire, and payrolling services to Fortune 500 companies nationally, as well as small to mid-sized organizations on a local & regional level. Currently, Amerit has over 2,000 employees in 47 states. We develop and implement solutions that help our clients operate more efficiently, deliver greater customer satisfaction, and see a positive impact on their bottom line. We create value by bringing together the right people to achieve results. Our clients and employees say they choose to work with Amerit because of how we work with them - with service that exceeds their expectations and a personal commitment to their success. Our deep expertise in human capital management has fueled our expansion into direct hire placements, temporary staffing, contract placements, and additional staffing and consulting services that propel our clients businesses forward.

Amerit Consulting provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.

This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training.

Applicants, with criminal histories, are considered in a manner that is consistent with local, state and federal laws