Back to listings
Employment Requirements
This opportunity is not open to C2C relationships or visa sponsorship.
This is opportunity is for local candidates only.
Job Description
The Database Administrator Sr/Lead performs administration duties for database infrastructure supporting enterprise business applications. This will include design, development, implementation, documentation, and optimization of an assortment of solutions primarily within the Microsoft suite of technologies. The Database Administrator Sr/Lead will also be working on system migrations and ETL processes that move data between our systems and our partners.
Responsibilities
Responsible for installing and maintaining instances of SQL Server. Areas of focus would be on performance tuning servers/databases, enterprise database security, backups/restores, disaster recovery and testing of them, automation of alerts and standard maintenance tasks
Identifies areas that require performance tuning within databases and coordinate with partners to recommend and implement changes. Tuning should occur on both the server/database configuration level as well as code level recommendations such as stored procedures, indexes and views.
Documents current database environment including servers, licensing, security, capacity planning, backups and disaster recovery plans.
Maintains current knowledge of database technology.
Qualifications
Experience with virtual environments (VMWare, Hyper-V)
Experience installing, patching and upgrading SQL Server databases
Experience with high availability technologies such as log shipping, mirroring, clustering and AlwaysOn Knowledge, skills, and abilities: Knowledge of:
The concepts of normalization and referential integrity
Writing automation scripts, functions and packages for administration and application support
The basic indexing concepts, such as the difference between clustered/non-clustered Skill in:
Written and verbal communication
Strong analytical and troubleshooting skills
Knowing the difference between DML and DDL
Knowing what a query plan is and how to review one
Knowing the purpose of primary, foreign, and unique keys
Installing, configuring SQL Server services: SSAS, SSIS, SSRS
Creating cubes, packages and reports using the above technologies
Ability to solve complex system and database environment issues
Two (2) years’ experience with Data Modeling, Data Warehousing, and structuring data for Business Intelligence
This opportunity is not open to C2C relationships or visa sponsorship.
This is opportunity is for local candidates only.
Job Description
The Database Administrator Sr/Lead performs administration duties for database infrastructure supporting enterprise business applications. This will include design, development, implementation, documentation, and optimization of an assortment of solutions primarily within the Microsoft suite of technologies. The Database Administrator Sr/Lead will also be working on system migrations and ETL processes that move data between our systems and our partners.
Responsibilities
Responsible for installing and maintaining instances of SQL Server. Areas of focus would be on performance tuning servers/databases, enterprise database security, backups/restores, disaster recovery and testing of them, automation of alerts and standard maintenance tasks
Identifies areas that require performance tuning within databases and coordinate with partners to recommend and implement changes. Tuning should occur on both the server/database configuration level as well as code level recommendations such as stored procedures, indexes and views.
Documents current database environment including servers, licensing, security, capacity planning, backups and disaster recovery plans.
Maintains current knowledge of database technology.
Qualifications
Experience with virtual environments (VMWare, Hyper-V)
Experience installing, patching and upgrading SQL Server databases
Experience with high availability technologies such as log shipping, mirroring, clustering and AlwaysOn Knowledge, skills, and abilities: Knowledge of:
The concepts of normalization and referential integrity
Writing automation scripts, functions and packages for administration and application support
The basic indexing concepts, such as the difference between clustered/non-clustered Skill in:
Written and verbal communication
Strong analytical and troubleshooting skills
Knowing the difference between DML and DDL
Knowing what a query plan is and how to review one
Knowing the purpose of primary, foreign, and unique keys
Installing, configuring SQL Server services: SSAS, SSIS, SSRS
Creating cubes, packages and reports using the above technologies
Ability to solve complex system and database environment issues
Two (2) years’ experience with Data Modeling, Data Warehousing, and structuring data for Business Intelligence