Hello,
Hope you are doing great!
Kindly find below requirement if you feel comfortable with job description kindly share your updated resume at abhartiya@shiftcodeanalytics.com
Job Title- SQL DBA
Location: Remote Role
Duration: 6+ Months Contract
Visa – USC, GC, GC EAD and H4 EAD
Must Have Experience with Amazon Web Services (AWS)
Responsibilities:
Client is looking for a database administration resource to maintain Commerce database environments and instances and to assist with critical Commerce projects.
Commerce oversees more than 40 industries and depends heavily on software solutions to meet its responsibilities. Having secure, available databases that have the correct data sets for reports and analytics is a critical aspect of these software solutions. The resource under this engagement will maintain databases for Commerce's software solutions and analytical needs. The resource will also provide support for modernization projects involving databases, including setting up a data warehouse on AWS. The ideal candidate will be a high-level database administrator who is able to work with minimal oversight and craft database solutions that they can share with State staff and subsequently implement.
The databases are a mix of SQL Server, Oracle, and PostGRES. All but one of the databases are housed on Amazon Cloud. One SQL Server database is hosted locally at MNIT.
Project Schedule
Maintain SQL Server, Oracle, and PostGRES instances, schemas, and tables located on the Amazon Cloud
- Maintain SQL Server instances, schemas, and tables hosted at MNIT
- Create basic data models and documentation
- Identify unused or duplicate tables for deletion
- Implement best practices for SQL Server, Oracle, and PostGRES
- Respond to and carry out database work requests
- Perform performance tuning and optimization as applicable
- Create and maintain ETL (Extraction, Translate, Load) for data submissions
- Create data sets for Tableau use
- Assist with database aspect for projects including setting up a data warehouse and software rewrites
- Create documentation for work completed
- Provide knowledge transfer to State staff
- Perform other related duties as assigned
Minimum Qualifications
- Five (5) years' combined experience in SQL Server, Oracle, and PostGRES database management, which includes at least six (6) months of experience in each of these databases
- Five (5) years' experience in database migration using ETL tool(s)
- Five (5) years' experience with performance analysis tool(s)
- Two (2) engagements lasting at least six (6) months each in lead database administration roles
Desired Qualifications
- Experience with Amazon Web Services (AWS)
- Experience with data modeling
- Experience with advanced analytical design tools
- Experience with disaster and recovery planning
- Experience with cost benefit analysis
- Experience with three tier architecture concepts and configurations
Regards,
Abhishek Bhartiya
Recruitment Team Lead
ShiftCode Analytics Inc.,
5118 Sylvester loop Tampa,
Florida 33610
Direct: 813-535-8497
Email: abhartiya@shiftcodeanalytics.com
URL: http://www.shiftcodeanalytics.com/
..............................
