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
10856 Menands, NY 12204 Sybase Administrator: ASE, DBMS, Replication Server, 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=10856 (Sybase Administrator: ASE, DBMS, Replication Server, Transact SQL, Embarcadero’s DB Artisan) in Menands NY 12204 (NON)

Estimated Length: 3 months 8 hour works days performed generally between the hours of 7 a.m. and 5 p.m., Monday through Friday.  

Mandatory Requirements

Skill Level:  Junior (12-36 months)

Desired Requirements

  • 36 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.
  • 36 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.
  • 36 Months of experience performing Sybase optimization analysis and implementing resolutions.
  • 36 Months of experience working with Transact SQL and Sybase Data.
  • 36 Months of experience maintaining and troubleshooting Cobol reports using embedded SQL.
  • 36 Months of experience working with end users providing DB support.
  • 36 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

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