Under Development Features: Talent Bank/Pool, VMS Intigration, Analytics, Social Integration, Reports, API Integration, Resource and Timesheets Management, Company Admin

SQL Database Architect (Sybase PowerBuilder, SSMA) (217 views)

Portland, OR
March 9, 2021

***** Direct Client Requirement*****                    

Title                          : SQL Database Architect (Sybase PowerBuilder, SSMA)

Location                   : Portland, OR

Rate                          : DOE /If your experience and skills match call us immediately for submission

Duration                  : 12 Months

Interview Type       : Skype or Phone

Work Status           : Successful applicants must be legally authorized to work in the U.S

Job Type                  : C2C,C2H, W2

Experience              : 12 years

Prefer W2               : U S C/ G C /H1B Transfer/OPT/CPT/H4 EAD and other US work authorization are accepted

Job Description:

The Office of Information Services (OIS) is a shared service provider for the Oregon Health Authority (OHA) and Oregon Department of Human Services (ODHS). OIS provides the technology systems and services that support more than 11,000 OHA and ODHS agency staff at local offices and facilities around the state. These systems and services help the two agencies determine client service program eligibility; provide medical, housing, food and job assistance; provide addiction, mental health, vocational and rehabilitative services; protect children, seniors and people with physical and/or developmental disabilities; process claims and benefits; manage provider licensing and state hospital facilities; and promote and protect the state public health.        

  • OIS seeks an experienced Database ArchitectIV with expertise in analyzing existing Sybase data architectures and performing database migrations between Sybase and MSSqlServer in accordance with business, data security, and regulatory requirements.
  • This contract position will fulfill OIS objectives of decommissioning existing Sybase databases. For this engagement, this includes the migration of an existing Sybase database and migration of that database to MSSqlServer. This includes Stored Procedures, PowerBuilder objects, joins and transaction objects. The existing Sybase database supports a set of applications within the Nutrition Health Screening section, which includes the FamilyNet and WIC (Women, Infants, Children) applications. The applications are written in Sybase PowerBuilder. The outcome of this migration project is to have the PowerBuilder applications maintain all existing functionality once migration to MSSqlServer is complete.  
  • Contractor’s Key Person will work with OIS technical staff and business program personnel to develop a strategic roadmap to develop and execute the database migration effort.

Scope:

  • Contractor’s Key Person under this WOC will participate in setting the strategic direction for the database migration. Contractor’s Key Person will provide expertise in the planning efforts to identify tasks and deliverables. The Contractor’s Key person with then execute those tasks to complete the migration.

Tasks:

Contractor’s Key Person shall:

  • Audit existing data systems; models, queries, stored procedures, security, etc. and provide recommendations and a suggested roadmap for migration.
  • Develop and implement recommended strategy for migration of schema.
  • Implement conversion of PowerBuilder Window Objects.
  • Develop recommended data standards for bulk data migration (e.g. BCP scripts).
  • Modify Transaction objects for new MSSqlServer database.
  • Maintain existing data security and access models.
  • Develop database administration standards and processes, including change control, to inform Agency’s SDLC process, and train staff in the application and use of these standards and processes.
  • Develop a data (or database) change request process with the developer and Data Resource Management teams

Required skills and experience:

  • Data Analysis
  • Data Modeling
  • Database Migration
  • Sybase
  • MSSqlServer
  • Transact SQL
  • Stored procedures

In addition, the ideal candidate will have skills and experience in:

  • Experience of familiarity with PowerBuilder
  • SSMA – SQLServer Migration Assistant
  • BCP scripts
  • Conversion of PowerBuilder Window Objects
  • Please make sure resumes submitted CLEARLY reflect the required skills and experience. Resumes that do not reflect the required skills will be rejected, regardless of how you respond to the Qualifications section.
  • Interviews will be conducted via MS Teams. Interview times will reflect Pacific Standard Time.
  • Due to circumstances beyond our control, we anticipate two weeks or more for the background check completion for the selected candidate.

    Key Person shall work remotely.

  • As agreed to between the Agency Authorized Representative and the key person, any decision to allow telecommuting is made with the understanding that decision will be re-evaluated by the Agency Authorized Representative on a regular basis. The key person should be available to work onsite within a reasonable timeframe.

  • Telecommuting will be contingent upon the key person providing his/her own adequate computer, monitor(s), Internet connection, and telephone, and be readily available during normal working hours via phone, email or instant message. Access to Agency systems will be provided via Citrix Remote Desktop or similar software. No hardware or additional software will be provided at the key person’s home site or his/her PC.
  • If the Agency Authorized Representative and key person agree to allow off-site work, the expectation is for that key person to work onsite as soon as the general workforce transitions back into the Agency workplace.
  • Work schedule is typically Monday – Friday, 8 AM – 5 PM Pacific Standard Time.

Qualifications    

o Database          Data Analysis                                   Advanced Yes
o Database          Data Modeling                                  Advanced Yes
o Database                  DBA                                          Advanced Yes
o Database   Microsoft SQL Server                               Advanced Yes
o Languages       PL/SQL                                              Advanced Yes
o Languages       SQL                                                    Advanced Yes
o Others SSMA (SqlServer Migration Assistant) 
 Experience Required: 6 – 7 years                              Proficient Yes
o Others Transaction Objects
 Experience Required: 6 – 7 years                               Proficient Yes
o Others Transact-SQL
 Experience Required: 6 – 7 years                               Proficient Yes
o Others PowerBuilder                                                   Advanced Yes
o Others BCP Scripts Experience Required: 6 – 7 years Proficient Yes
o Others Communication skills both verbal and written  Advanced Yes
o Others Consolidation planning and management
 Experience Required: 6 – 7 years                               Proficient Yes
o Others Data center management
 Experience Required: 6 – 7 years                                Proficient Yes
o Others Presentation skills Advanced Yes
o Others Team work Experience Required: 6 – 7 year s Proficient Yes
o Tools Sybase PowerBuilder                                          Advanced Yes
o Tools VisualStudio                                                        Advanced Yes

*****Referral Bonus Available: Refer your friends or colleagues, get referral bonus******

Thanks

Vinay/Siva
Vinayp@Sohanit.com/Siva@sohanit.com
PH:402-241-9613/402-241-9606
Apply here or Please send to resumes@sohanit.com

Follow us on LinkedIn and Twitter for daily active requirements

LinkedIn: https://www.linkedin.com/company/sohanit-inc/?viewAsMember=true
Twitter: https://twitter.com/SohanITInc1

Position Keywords: Sybase MSSqlServer,PL/SQL,SQL,SSMA (SqlServer Migration Assistant),Transaction Objects,Transact-SQL,PowerBuilder,BCP Scripts,Data center management,Sybase PowerBuilder,VisualStudio

Pay Rate: DOE/If your experience and skills match call us immediately for submission

Job Duration: 6 Months

% Travel Required: None

Job Posted by: Consulting Services

Job ID: OOJ - 2870

Work Authorization: Successful applicants must be legally authorized to work in the U.S

Don't have time now?
Get a reminder in your inbox