Overview
Accepts corp to corp applications
Contract - Independent
Contract - W2
Skills
UI
Information Technology
Network
Microsoft
Tier 1
Recruiting
Training
Partnership
LINQ
Entity Framework
Remote Desktop Services
Amazon RDS
Virtual Machines
PostgreSQL
Quality Assurance
Backup Administration
Database
ProVision
Management
Ad Hoc Reporting
Auditing
Communication
Production Support
Microsoft SQL Server DBA
Amazon Web Services
Google Cloud
Google Cloud Platform
Cloud Computing
Transact-SQL
DML
DDL
Microsoft SQL Server Management Studio (SSMS)
Debugging
Statistics
SLA
Microsoft SQL Server
Business Continuity Planning
Microsoft SSIS
Windows PowerShell
Bash
Version Control
Git
Microsoft TFS
Apache Subversion
High Availability
Medicaid
Medicare
SAP GRC
MySQL
MongoDB
Health Care
JIRA
Confluence
Bitbucket
Data Modeling
Replication
.NET
Python
Job Details
CCS Global Tech is a rapidly growing Information Technology company with a diverse portfolio of technology products and services and a large network of industry partnerships. With over 22 years of being a successful business with a global talent pool and presence, CCS is a certified Microsoft Gold Partner and specializes in delivering expert Microsoft based solutions for technical and business needs. We have been recognized by Inc. 500 Magazine as one of the fastest growing small companies in the Unites States.
we are a Tier 1 vendor for the City and County of San Francisco for Cloud Services, Staffing Services and Training Services. For this multi-year opportunity with a diverse set of needs to address, we are currently focusing on establishing partnerships with individuals as well as companies who can help us enhance our overall service portfolio, cut lead times, and ultimately help us deliver successfully. We currently hold sizable Government accounts in the San Francisco bay area including City and County of San Francisco, San Mateo County, and Santa Clara County.
We take great pride in our global reach and local influence. Your experience alongside our highly skilled and talented internal team who guide you along the way, offers key insights into what helps you stand out in a competitive job market.
If you are a partner company, please submit resumes with contact information of your own W2 Consultants only. Submitted consultants are expected to have excellent communication skills.
Job Title: SQL Server DBA
Location: Remote(NY/NJ)
We are looking for an experienced SQL Server DBA with management experience to support our production and non-production environments. The role provides day-to-day database support for .NET (LINQ/Entity Framework) applications using SQL Server running primarily on AWS RDS. SQL Server constitutes 95% of our database environment but we do support other platforms. We also support RDS instances and VMs running Postgres, MySQL, and MongoDB. We are a 24/7/365 organization, and this role requires participation in an on-call rotation
Key Responsibilities:
- Use monitoring tools to diagnose performance opportunities and provide suggestions and feedback to developers
- Support the QA and dev teams with backups/restores of databases and instance snapshots
- Manage assigned tasks within the Jira ticket system
- Provision access to users
- Participate in weekly production code releases and hot fixes
- Manage replication jobs in data replication tool (Cloud Basic)
- Review Git pull requests that relate to data model, query, or schema changes
- Respond to ad hoc reporting requests
- Apply patches and updates
- Assist auditors in responding to internal and external audit requests
- Provide cross-functional communication and support to engineering and product teams
Requirements:
- 5 + years of experience as a production support SQL Server DBA, preferably in an AWS or Google Cloud Platform environment, or in other cloud environments (or related data systems experience)
- Proficient with TSQL, DML, DDL, SSMS
- Strong troubleshooting and debugging skills
- Must understand how to interpret a query plan, have deep knowledge of indexes and statistics
- Able to respond to calls within the SLA when on-call
- Able to import/export data using common SQL Server tools such as BCP, SSIS or PowerShell
- Proficient with PowerShell (particularly dbatools) and a working knowledge of Bash
- Experience with source control systems such as Git, TFS, SVN
- Passion for embracing and learning new technologies
- Experience with High Availability techniques to ensure maximum uptime when adding indexes, modifying large amounts of data, patching, and re-sizing instances.
- Experience working with government (Medicaid, Medicare) security and government policies such as ISPE, ARS, GRC.
Bonus Skills:
- MySQL, MongoDB, PBM or healthcare-based business experience preferred
- Jira, Confluence, Bitbucket, Data modelling, Replication (any),.NET, Python
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.