SQL DBA (Ref: 353838)
Company Name:
Professional Technology Integration Inc
Position: SQL DBA (Ref: 353838)
Location: Little Rock, AR 72201
Salary: $50 /hr.
Duration: 1.5
Years - Contract
Description
The SQL Database Administrator (DBA) implements, monitors and maintains the enterprise database environment. The primary responsibility for the first six months will be the migration of the legacy systems to SQL server 2012 environment.
The primary responsibility includes migration of the legacy systems to SQL server 2012 environment. After the migration the DBA will begin more typical DBA duties that will include assisting with application development, support and maintenance initiatives, from a database perspective, and is responsible for database configuration, debugging and optimization activities. The DBA will also be closely involved in the design, implementation, and on-going support of an Enterprise Data Warehouse.
Bachelors Degree in
information technology
,
computer
Science, Engineering, or related discipline, or equivalent work experience is required.
Qualifications
3
years experience migrating Legacy DB to SQL Server
6
years experience with SQL Server Database Administration (2000/2005/2008 R2 and/or 2012).
Experience in migration of SQL Server 2000 to 2008R2 and 2012 environment.
Experience in troubleshooting and resolving database problems including performance, integrity, blocking and deadlocking and security issues.
Experience in Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools.
Experience with backups, restores and recovery models.
Design and develop data models and database architecture.
Develop and enhance stored procedures, triggers, functions, views and other database objects.
Create SSIS packages to load, transform and process data.
Develop scripts to automate administration and management of the environment.
Resolve database production issues, code troubleshooting.
Database tuning and monitoring.
Create technical specifications and support documentation.
Able to work in a fast changing environment.
Research and introduce new database technologies.
Knowledge of indexes, index management, and statistics.
Experience with SQL Integration
services
in order to manage/maintain data warehouse technologies including ETL process.
Knowledge in creating report using Crystal Reports and SSRS.
Job Responsibilities
Performs the following activities: requirements gathering, definition, development, testing and implementation.
Gains necessary input/approval of requirements and design and participates in code reviews.
Ensures applications meet requirements and is error free.
Develops technical system documentation.
Builds enterprise architectural and/or infrastructure components.
Ensures that applications meet architectural standards.
Supports the operations of existing applications.
Adheres to a productions support process.
Application maintenance.
Works on a periodic maintenance releases of applications including enhancements and defects.
Looks for ways to enhance design of application for better maintainability and software reuse.
Looks for ways to incrementally improve the architecture of legacy systems business alignment.
Anticipates users future needs when architecting solutions.
Skill Required / Desired
Database Migration from Legacy to SQL Server Required 3 Years
SQL Server Database Administration (2000/2005/2008 R2 and/or 2012) Highly desired 6 Years
SQL Server 2000 to 2008R2 and 2012 Required 6 Years
Troubleshooting and resolving database problems Required 6 Years
Integrity, blocking, Deadlocking and Security Issues Required 6 Years
Performance Tuning and Optimization (PTO) Required 6 Years
Design and develop data models and database architecture Required 6 Years
Create SSIS packages to load, transform and process data Required 6 Years
Develop scripts to automate administration and management Required 6 Years
Resolve database production issues, code troubleshooting Required 6 YearsEstimated Salary: $20 to $28 per hour based on qualifications.
Professional Technology Integration Inc
Position: SQL DBA (Ref: 353838)
Location: Little Rock, AR 72201
Salary: $50 /hr.
Duration: 1.5
Years - Contract
Description
The SQL Database Administrator (DBA) implements, monitors and maintains the enterprise database environment. The primary responsibility for the first six months will be the migration of the legacy systems to SQL server 2012 environment.
The primary responsibility includes migration of the legacy systems to SQL server 2012 environment. After the migration the DBA will begin more typical DBA duties that will include assisting with application development, support and maintenance initiatives, from a database perspective, and is responsible for database configuration, debugging and optimization activities. The DBA will also be closely involved in the design, implementation, and on-going support of an Enterprise Data Warehouse.
Bachelors Degree in
information technology
,
computer
Science, Engineering, or related discipline, or equivalent work experience is required.
Qualifications
3
years experience migrating Legacy DB to SQL Server
6
years experience with SQL Server Database Administration (2000/2005/2008 R2 and/or 2012).
Experience in migration of SQL Server 2000 to 2008R2 and 2012 environment.
Experience in troubleshooting and resolving database problems including performance, integrity, blocking and deadlocking and security issues.
Experience in Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools.
Experience with backups, restores and recovery models.
Design and develop data models and database architecture.
Develop and enhance stored procedures, triggers, functions, views and other database objects.
Create SSIS packages to load, transform and process data.
Develop scripts to automate administration and management of the environment.
Resolve database production issues, code troubleshooting.
Database tuning and monitoring.
Create technical specifications and support documentation.
Able to work in a fast changing environment.
Research and introduce new database technologies.
Knowledge of indexes, index management, and statistics.
Experience with SQL Integration
services
in order to manage/maintain data warehouse technologies including ETL process.
Knowledge in creating report using Crystal Reports and SSRS.
Job Responsibilities
Performs the following activities: requirements gathering, definition, development, testing and implementation.
Gains necessary input/approval of requirements and design and participates in code reviews.
Ensures applications meet requirements and is error free.
Develops technical system documentation.
Builds enterprise architectural and/or infrastructure components.
Ensures that applications meet architectural standards.
Supports the operations of existing applications.
Adheres to a productions support process.
Application maintenance.
Works on a periodic maintenance releases of applications including enhancements and defects.
Looks for ways to enhance design of application for better maintainability and software reuse.
Looks for ways to incrementally improve the architecture of legacy systems business alignment.
Anticipates users future needs when architecting solutions.
Skill Required / Desired
Database Migration from Legacy to SQL Server Required 3 Years
SQL Server Database Administration (2000/2005/2008 R2 and/or 2012) Highly desired 6 Years
SQL Server 2000 to 2008R2 and 2012 Required 6 Years
Troubleshooting and resolving database problems Required 6 Years
Integrity, blocking, Deadlocking and Security Issues Required 6 Years
Performance Tuning and Optimization (PTO) Required 6 Years
Design and develop data models and database architecture Required 6 Years
Create SSIS packages to load, transform and process data Required 6 Years
Develop scripts to automate administration and management Required 6 Years
Resolve database production issues, code troubleshooting Required 6 YearsEstimated Salary: $20 to $28 per hour based on qualifications.
|
|
 | |
