SQL Server DBA - Plymouth Meeting, PA - Georgia IT Inc.
Plymouth Meeting, PA
About the Job
Job Title : SQL Server DBA
Location : Plymouth Meeting, PA
Position Type : Contract
Rate : Doe
US Citizen, Green Card, GC EAD, H4 EAD and TN (Not for H1b or OPT EAD).
Skills Required:
Location : Plymouth Meeting, PA
Position Type : Contract
Rate : Doe
US Citizen, Green Card, GC EAD, H4 EAD and TN (Not for H1b or OPT EAD).
Skills Required:
- Knowledge of SQL Server Database (2008 R2, 2016) required.
- Knowledge of SSIS Tools in SQL Server 2008 R2 and SQL2016 very helpful.
- Strong skills in use of Microsoft Office tools (VBA knowledge a plus)
- Ability to write SQL Scripts (functions, stored procedures) to automate routine data research tasks.
- Familiarity with pharmaceutical promotion and treatment data is a plus.
- Ability to work alone or as part of a team to achieve stated goals.
- Knowledge of Microstrategy Tools with regard to creating and troubleshooting reports a plus (not a requirement).
- Very good verbal and written skills.
- Respond to requests for data or analysis of data and associated processing.
- Assist in triage of data and reporting issues related to CDOM and Microstrategy and then implement or recommend changes to avoid future issues.
- Maintain SQL Scripts written by current and former employees.
- Reverse engineer queries in order to enhance existing processes.
- Perform any other tasks as assigned.
- Rewrite ETL process for redesigned Data Warehouse
- Maintain existing ETL process until it can be retired.
- Monitor nightly backups to insure they all run correctly and on time.
Source : Georgia IT Inc.