IIT Inc. Home

IIT Jobs Data Bank-Job Detail

Submit Resume For This Job (via email)
Follow us on LinkedIn or Twitter or Facebook
Follow us on Facebook Follow us on LinkedIn
ID Location Skills $$ Job Type Status
10976 Menands, NY 12204 Sybase DBA: Sybase ASE, DBMS, Replication Systems, Transact SQL, Embarcadero’s DB Artisan DOE Contract OPEN
If you are unable to click on links above to submit resume, you may email your resume to
1193-MH2857@apply.maxhire.net    

Subject=IIT Career Site/Resume for JobID=10976 (Sybase DBA: Sybase ASE, DBMS, Replication Systems, Transact SQL, Embarcadero’s DB Artisan) in Menands NY 12204 (BOB)

Estimated Length: 6 months Full-Time 8-hour work days

Mandatory Requirements

Skill Level:  Expert (84 months)

Desired Requirements

  • 84 Months of experience establishing, maintaining and troubleshooting Sybase ASE (Version 11.9.2 or later) DBMS in an enterprise-wide database of over 200GB+ within a Windows environment.
  • 84 Months of experience establishing, maintaining and troubleshooting complex Sybase Data Replication Systems (65+ Replication Databases and 200GB+ Database as Central Repository) in a Windows environment using Replication Server Version 11.5 or later.
  • 60 Months of experience performing Sybase optimization analysis and implementing resolutions.
  • 60 Months of experience working with Transact SQL and Sybase Data.
  • 48 Months of experience maintaining and troubleshooting Cobol reports using embedded SQL.
  • 48 Months of experience working with end users providing DB support.
  • 48 Months of Experience using Embarcadero’s DB Artisan for Sybase administration.
  • 12 Months of experience maintaining and troubleshooting Sybase Sql Anywhere (Version 11.0.0 or later)
  • Bachelor’s Degree in an Information Technology related field, from an accredited institution.

Responsibilities

  • Provide support for the administration and maintenance of all Sybase databases and user accounts.
  • Monitor applications use of the databases and make recommendations to improve efficiency and response time.
  • Set up, monitor, and update jobs performing data backups and recoveries.
  • Monitor database usage, identify corrective actions when necessary and apply changes needed to handle data growth and performance degradation (data archival, DB size increase, indexing, etc.)
  • Perform impact analysis on hardware configurations, database schema, and application code, to offer recommendations on improving design and efficiency.
  • Write SQL code via stored procedures and Transact-SQL to access data.
  • Develop database designs by performing needs analysis, creating logical model, and implementing the physical model.
  • Follow/develop sound database practices.
  • Ensure databases are available to users during business working hours and any routine maintenance is performed off hours.
  • Install, configure, patch, and upgrade Sybase ASE and Replication.
  • Monitor disk space utilization and logs and notify appropriate staff when additional resources are needed.
  • Assist staff in setting up, maintaining, backing up and restoring databases in test environments.
  • Provide troubleshooting support with COBOL Reports using embedded SQL
  • Implement and manage Sybase database replications among a large number of ASE servers located across NYS.
  • Monitor replication to ensure the data is being properly replicated from/to laptop servers to our enterprise servers.
  • Install, configure, and test new databases on laptop servers and set up replication with our main site.
  • Assist in reviewing and modifying a disaster recovery plan that allows for continuation of service using our hot site.
  • Run database jobs, i.e. reorgs, imports and exports, backups, etc.
  • Monitor database security and assign user permissions, develop groups, assign roles, audit access, etc.
  • Troubleshoot issues and take corrective actions as needed.
  • Monitor data integrity to ensure data is not damaged and/or corrupt.
  • Create and maintain documentation related to all tasks and provide mentoring/knowledge transfer to other staff within the Database group.
 
Submit Resume For This Job (via email)
 
Don't See a Position Matching Your Skills?
Click here to Email / Register your resume and be notified of future job openings.
 
About IIT:

Founded in 1995, IIT is a leading provider of Workforce Solutions to Government and Fortune-1000 organizations. IIT is a winner of Inc-500 award. IIT's core services include:

  • Consulting for projects / IT Outsourcing
  • IT staffing (Contract / Temporary / Contingent / Consulting)
  • Custom Workforce Solutions
  • Recruitment Process Outsourcing (RPO)
  • Headquartered in New York, IIT has over 400 consultants deployed at Client Sites. Other IIT highlights include

  • Winner of Inc-500 award 2 consecutive years
  • Winner of Ernst & Young / USPAACC Fast-50 award 2 consecutive years
  • Winner of USPAACC Top-10 Award in the Northeast US
  • IBM Business Partner
  • Oracle Business Partner
  • Adobe Business Partner
  • NYSA Member - New York Staffing Association - Regional Affiliate of ASA / American Staffing Association
  • NYS MBE certified
  • Our Consultants love working for IIT

  • Competitive compensation
  • W2 or C2C
  • Biweekly Direct Deposit for W2 Consultants
  • Visa and Green Card sponsorship opportunities for qualified individuals
  • Local contact for you to meet and talk to anytime (not someone sitting overseas in a different time zone)
  • Follow us on LinkedIn or Twitter or Facebook

    IIT is an Equal Opportunity Employer