SQL Database Administrator
Company: Carollo Engineers, Inc.
Location: Phoenix
Posted on: September 16, 2021
|
|
|
Job Description:
An Insight Global client is looking for a SQL Database
Administrator to conduct the below:
The SQL Database Administrator will be responsible for designing
and maintaining Carollos SQL Server infrastructure adhering to
corporate requirements and standards. Responsibilities include all
aspects of the database administration and cross-functional teams
that align and lift Carollo's strategic initiatives. The SQL Server
DBA will deliver quality recommendations, process-changing ideas,
and design that drive new and significant improvement within the IT
department, Applications team, business, and applications. The DBA
is a hands-on technical role with opportunity to grow, learn,
experience technical diversity on daily basis, and a member of a
driven Applications team. This position will report to the IT
Apps-Dev Lead.
This person will also own the following:
Oversee the maintenance, configuration, and implementation of
everything that has to do with databases. This includes the
replication, backup, storage, access and partitioning of
databases
Consulting with business owners and application architects on all
strategic deployments, generating architectural design documents,
generating SSIS packages and SSRS reports and BI platform, and
presenting design concepts and solutions to internal customers
Installations, configurations, troubleshooting, and maintenance of
database systems
Manage the design and implementation of security and data access
methods to ensure services are properly controlled, monitored and
audited
Develop and implement maintenance and administration procedures for
database systems including the usage of metrics to ensure optimal
performance
Work with 3rd party companies and consultants as needed to support
commercial applications to be install on Carollos database
infrastructure
Author, document and maintain scripts to perform various aspects of
data management and system administration
Setup and constantly improve maintenance, operational and
monitoring processes
Export/Import Replication, Maintaining back up jobs, Creating
Linked Server Objects
Experience in Database Mirroring, log shipping and DR
procedures
Experience in SQL transactional Replication
Supporting MS SQL databases in Microsoft clustered environments
MCDBA (Microsoft Certified Database Administrator)
certification
Ten (10) or more years of experience in database administration and
support
MS SQL Server experiences
SQL Availability groups is a plus
Experience supporting large systems (i.e. Intranet, ERP, CRM)
Five (5) or more years of experience in SQL database administration
and support
Database design, logical/physical data modeling/design, data
security and SSIS or similar ETL tools
Strong knowledge of data relationships, normalization, and
summarization
Implementing or maintaining stored procedures, views, and
triggers
SQL tuning, Data conversion / Migration, Supporting Development,
Test and Production System
Database maintenance, backup and recovery
Keywords: Carollo Engineers, Inc., Phoenix , SQL Database Administrator, Other , Phoenix, Arizona
|
Click
here to apply!
|
