Job Seekers, Please send resumes to resumes@hireitpeople.comShort Description: Database administrator needed to support AIRS system.
Complete Description: Local Candidates Preferred
Installing and Upgrading SQL Servers, including applying Service Packs
Monitoring Database Server health, and tuning
-Optimal server performance
-Monitor the error log or event log for database errors
-Routine database maintenance, and the overall system maintenance
Maintaining and managing SQL Server disk space to insure storage is properly utilized
Performing backup and recovery
-Establishing standards and schedules for database backups
-Developing recovery procedures for each database
-Making sure that the backup schedules meet the recovery requirements
Managing Database users and security
Working with developers to tune queries, how to use indexes, etc.
Log shipping, mirroring, high availability, transaction log
Transferring Data – importing and exporting data to and from the SQL Server
Creating and scheduling SQL Server jobs to perform database maintenance activity
-Rebuilding indexes
-Updating statistics
-Consistency check
Establishing and enforcing Standards
Creating and testing Disaster Recovery Plan
Providing 24 Hours support
Other Responsibilities:
Knowledge of using FTP software to transfer files to and from FTP Servers
SQL Server RDBMS Knowledge:
-SQL Server Version: SQL Server 2008, 2012 and 2014
-Good understanding of SQL Server Databases
-Knowledge of disk and tape backup
-Knowledge of restoring databases with point in time recover
-Knowledge of SQL Server Profiler, Index Tuning Advisor
-Knowledge of SQL Server Configuration Manager
Index tuning
Knowledge of using SQL Server Jobs and Scheduling
How to create Database Mail Profile, alerts, operators, linked servers
Knowledge of how to use integration services or SSIS Packages to import and export data from/to SQL Server Database
Good TSQL knowledge
Good Windows clustering skills and knowledge
Knowledge of MSDTC
Good understanding of SQL Server system databases
Knowledge of VMware host, guest, vCenter, data store
Software Knowledge:
Windows Server 2008 R2, 2012, 2012 R2
SQL Server 2008, SQL Server 2012 and SQL Server 2014
TSM backup solution
LiteSpeed backup solution
Strong communication skills, both written and oral
Execution of all responsibilities with little direct supervision of Team Lead
Skill | Required / Desired | Amount | of Experience |
SQL Server 2008, SQL Server 2012 and SQL Server 2014 | Required | 6 | Years |
TSQL Programming | Required | 6 | Years |
Mirroring, Snapshot, High Availability | Required | 3 | Years |
SQL Server Profiler, Index Tuning Advisor, SQL Server Configuration Manager | Required | 3 | Years |
Performance tuning | Required | 3 | Years |
SQL Server Jobs and Scheduling | Required | 3 | Years |
Integration services or SSIS Packages to import and export data from/to SQL | Required | 3 | Years |
Backup and Restoring databases with point in time recovery, TSM, LiteSpeed | Required | 3 | Years |
Windows Server Administration, Windows Clustering | Required | 3 | Years |
GenTax Tools like SQR, FCR, Migrations, Doc | Highly desired |
GenTax Specific Services | Highly desired |
