DB2 Systems Programmer - (US-PA-York)

DB2 Systems Programmer - (US-PA-York)

Compensation: $70K - $80K / Year
Minimum Education: Bachelors
Job Type: Full Time
Jobcode: BEFJA6

Responsible for installing and maintaining DB2 running on the IBM Mainframe, UDB running on Suse Linux and related software products while ensuring the highest levels of availability, reliability, and scalability. Provide support, analysis, and problem resolution for operational and performance related issues. Participate in the design of efficient database schemas 

Job Functions: 

§ Software Support 

- Installs, maintains and supports DB2, DB2 LUW, and related ISV products. 

- Manages and maintains the development, test, and production DB2 environments. 

- Develops and maintains operational procedures and standards needed to effectively and efficiently operate the 

z/OS environment. 

- Interfaces with software vendor representatives as needed to support and develop products. 

Manages and maintains change management of DB2 objects from test to production including any new object creation or modification to existing objects. Also includes bind/rebind responsibilities for developers. 
- Analyzes and corrects any failures of DB2 nightly batch jobs. 

- Assists with application performance and tuning for specific applications. 

- Assists developers with debugging of Stored Procedures and Triggers. 

- Performs SQL analysis. 

§ Implements batch schedules for utility processing (Image Copy, Reorg, Runstats, Modify). 

- Monitors all jobs related to database reorganizations. 

- Maintains complete records of databases, tables, records, etc. 

Ensures safety and security of information systems assets and protects systems from inappropriate access or destruction. 
- Works with Security groups to insure proper DB2 authorizations are in place. 



Maintains the dictionaries/catalogs including creation, modification and deletion of all entity types. 
- Maintains elements, records, rows, tables, views and other entities. 

- Coordinates naming of elements to ensure naming standards are followed and created for all entities in the dictionary/catalog. 



Assists programming department in creation of efficient coding techniques for database access and DB2 related work. 


Develops and enhances administration procedures, tools and processes. 


Completes additional tasks as assigned. 
Requirements: 
- Knowledge of one or more applications. 

- Knowledge of z/OS operating systems. 

- Knowledge of Suse Linux operating system. 

- Knowledge of database systems, catalogs and access methods. 

- Ability to exercise independent judgment. 

- Ability to troubleshoot. 

- Ability to effectively prioritize and plan work. 

- Ability to organize, prepare and present data. 

- Ability to advise and interpret on application of policies, procedures, and standards involving programming needs. 


Email resume in Word to TheBigGameHunter@cisny.com. Please include the job code for the position with your resume. 

NO OVERSEAS RESUMES. NO 3RD PARTIES. 

To receive a complimentary subscription to my job search ezine, No B.S. Job Search Advice, go to www.JeffAltman.com to subscribe. Receive tweets from Twitter with job search tips – TheBigGameHuntr AND become a fan on Facebook http://goo.gl/Argw 

Webmaster - (US-PA-York)

Webmaster - (US-PA-York)

Compensation: $65K - $75K / Year
Minimum Education: Bachelors
Job Type: Full Time
Jobcode: BEFJA5

3-5 years experience. No job hoppers or consultants. Prefer people out of fast paced environments. 

The Web Technologies group is responsible for the infrastructure of the the $10 million ecommerce business. They support .NET technologies, IIS hardware and software. 

The Web Technologies Analyst will be hands on in architecture, design, development, integration and deployment of web applications and web services 

Functions: 
- Main and further develop a stable reliable and growing web environment to support internal and external facing applications. 
-Seeks out emerging technologies information and provides management reviews of applicability 
- Uses the preferred application performance monitoring tool to identify opportunities to ensure the web services are 
processing in the most efficient manner 
-Troubleshoots website and web services issues and recommends improvements to meet project, program and department objectives for quality, efficiency, productivity and integrity 
- Works closely with users, developers and software.hardware vendors to identify and correct failing components of the web 
infrastructure 
- Consults on costs and benefits of platform enhancements 
- Develops alternative approaches to system processes 
- Performs routine and recommended maintenance upgrades 
- Provides consultation to application development teams on technical issues. Assists the programming department in creation of 
efficient coding techniques for web applications services 
- Develops and maintains adequate technical documentation on software configurations, installation instructions network diagrams, backup/recovery, standards and other related information 

Requirements: 
- Experience and understanding of SOA, Web Services, SOAP 
- Experience with web environments running IIS, Websphere 
- Strong software design skills 
- Experience with the following technologies: VMWare, SCOM, APM tools 
- Experience with Linux and Windows operating systems 
- Direct experience working with relational databases (SQL, DB2) 
- Excellent verbal and communication skills 
- Commitment to deadlines to meet the needs of a 24x7 environment. Ability to work on a on call rotation basis. 

Email resume in Word to TheBigGameHunter@cisny.com. Please include the job code for the position with your resume. 

NO OVERSEAS RESUMES. NO 3RD PARTIES. 

To receive a complimentary subscription to my job search ezine, No B.S. Job Search Advice, go to www.JeffAltman.com to subscribe. Receive tweets from Twitter with job search tips – TheBigGameHuntr AND become a fan on Facebook http://goo.gl/Argw