Optimal Solutions & Technologies (OST, Inc.) is focused on excellence. We specialize in providing Management Consulting, Information Technology, and Research Development and Engineering services. OST is one of an elite set of companies worldwide to be externally appraised CMMI Level 5.
The fundamental distinction of the OST team is its business knowledge in both the public and private sectors. We serve the aerospace & transportation, association & nonprofit, defense, education, energy, financial, healthcare, and technology & telecommunications industries. OST is successful because we listen to our clients, we learn from our clients, and we know our clients.
Engagement Length in Months:
3 years 4months.
What are the daily work hours?
Monday through Friday, 8am -5pm
Where is the physical work office located?
504 Mayflower Street, Baton Rouge, LA 70802.
(Contractor personnel, with permission of the Project Manager, will work offsite: State Remote or Contractor Remote)
Description of specific Duties in a typical workday for this position:
The Resource for this position is expected to perform tasks such as:
- Data Architecture
- Data Modeling
- Support for specific applications using databases
The ideal candidate will demonstration expert experience administering multiple relational databases such as Oracle, MS SQL, MySQL and PostgreSQL. Strong scripting skills (PowerShell, php, python, ruby, Perl, etc.). Knowledge of database connectivity issues. Strong analytical and troubleshooting skills.
The scope of the proposed services will include the following:
- Data Extraction, Transformation, and Loading
- Database Backup and Recovery
- Performance Monitoring
- Specialized Data Handling
- Database Tuning
- Capacity Planning
Expertise and/or relevant experience in the following areas are mandatory:
- SQL Server, Administration and Performance Tuning
- Index design
- Use DMO's to collect query data, index data
- Extended Events
- SSIS or other relevant ETL software
Expertise and/or relevant experience in the following areas are desirable but not mandatory:
- Familiarity with Web Based Applications, Entity Framework
- Database DevOps Practices
- SSRS
- SSAS
- PowerBI/Tableau or other BI Platforms
- Data Warehousing design
- SQL Server concurrency and isolation
- Data movement features of SQL Server
OST is an equal opportunity employer. Applicants are considered for positions without regard to race, religion, gender, native origin, age, disability, or any other category protected by applicable federal, state, or local laws.
|