What are the responsibilities and job description for the SQL DBA position at CereCore?
Classification: Contract-To-Hire
Contract Length: 12 Months
Position Summary
The SQL DBA - Senior Level develops, implements, administers, and maintains policies and procedures for ensuring the security and integrity of the company database. Implements data models, database designs, data access and table maintenance codes. Resolves database performance and capacity issues, and replication and other distributed data issues.
This position sits on the Corporate SQL DBA Team which support all the corporate MS SQL servers in environment which is about 1,300 servers spread across all of our Data Centers. This position is supporting a new project called SQL Lifecycle. In this role you will be working on getting all SQL 2012 and 2014 migrated to either new servers or to Azure and that’s what focus of this position will be. Migrating DB’s from one server to either new server or Azure. Qualified candidates need to have Azure experienced, experience going from on-prem to Azure and experience with server installs and replication configuration and support. A big part of this project is migrating DB’s off our SQL farms that have multiple DB’s and multiple app owners. Each one of those DB’s will have to be moved to another location. Qualified candidates will have strong soft skills and is someone who is good at communication because will be working with the PM and the application owners. Experience with ServiceNow is good for change tickets. Commvault for backup would be a plus.
Reviews, evaluates, designs, implements and maintains company database[s]. Identifies data sources, constructs data decomposition diagrams, provides data flow diagrams and documents the process. Writes codes for database access, modifications, and constructions including stored procedures. Requires a bachelor's degree in area of specialty and 6-8 years of experience in the field or in a related area. Familiar with a variety of the field's concepts, practices, and procedures. Relies on extensive experience and judgment to plan and accomplish goals. Performs a variety of tasks. Leads and directs the work of others. A wide degree of creativity and latitude is expected. Typically reports to a manager or head of a unit/department. Experience in MySQL, Oracle, or DB2 is required.
Responsibilities
Contract Length: 12 Months
Position Summary
The SQL DBA - Senior Level develops, implements, administers, and maintains policies and procedures for ensuring the security and integrity of the company database. Implements data models, database designs, data access and table maintenance codes. Resolves database performance and capacity issues, and replication and other distributed data issues.
This position sits on the Corporate SQL DBA Team which support all the corporate MS SQL servers in environment which is about 1,300 servers spread across all of our Data Centers. This position is supporting a new project called SQL Lifecycle. In this role you will be working on getting all SQL 2012 and 2014 migrated to either new servers or to Azure and that’s what focus of this position will be. Migrating DB’s from one server to either new server or Azure. Qualified candidates need to have Azure experienced, experience going from on-prem to Azure and experience with server installs and replication configuration and support. A big part of this project is migrating DB’s off our SQL farms that have multiple DB’s and multiple app owners. Each one of those DB’s will have to be moved to another location. Qualified candidates will have strong soft skills and is someone who is good at communication because will be working with the PM and the application owners. Experience with ServiceNow is good for change tickets. Commvault for backup would be a plus.
Reviews, evaluates, designs, implements and maintains company database[s]. Identifies data sources, constructs data decomposition diagrams, provides data flow diagrams and documents the process. Writes codes for database access, modifications, and constructions including stored procedures. Requires a bachelor's degree in area of specialty and 6-8 years of experience in the field or in a related area. Familiar with a variety of the field's concepts, practices, and procedures. Relies on extensive experience and judgment to plan and accomplish goals. Performs a variety of tasks. Leads and directs the work of others. A wide degree of creativity and latitude is expected. Typically reports to a manager or head of a unit/department. Experience in MySQL, Oracle, or DB2 is required.
Responsibilities
- Participate in SQL Lifecycle Management projects and activities
- Develops, implements, administers, and maintains policies and procedures for ensuring the security and integrity of the company database.
- Implements data models, database designs, data access and table maintenance codes.
- Resolves database performance and capacity issues, and replication and other distributed data issues.
- Work with application owners and stakeholders to successfully migrate 2012-2014 SQL servers to Azure
- 4-10 years of experience with SQL Database Administration
- Familiar with standard MS SQL DB and server concepts, practices, and procedures.
- Prior experience migrating MS SQL Servers to Azure
- Experience with server installs and replication configuration and support
