Wipro Limited (NYSE: WIT, BSE: 507685, NSE: WIPRO) is a leading technology services and consulting company focused on building innovative solutions that address clients' most complex digital transformation needs. Leveraging our holistic portfolio of capabilities in consulting, design, engineering, and operations, we help clients realize their boldest ambitions and build future-ready, sustainable businesses. With over 230,000 employees and business partners across 65 countries, we deliver on the promise of helping our customers, colleagues, and communities thrive in an ever-changing world. For additional information, visit us at www.wipro.com.
Job Description
Job Description:
The Mainframe Database Administrator (DBA) leads the planning, analysis, design, implementation, maintenance, and control of the organization's mainframe databases. The Mainframe DBA consults with and advises senior management and multiple clients on high impact data or database management issues, influencing strategic direction. Handles and leads various large-scale or highly complex data/database management activities including one or more of the following: designing highly complex logical and/or physical databases; leading highly complex data modeling, mapping, integration, and capacity planning efforts; developing management policies, procedures and standards; and business requirements identification, analysis and development. Provides mentoring, guidance and general oversight to less experienced staff in a variety of database design, administration and/or modeling activities. As a DBA administrator, you will be responsible for administering, testing, and implementing databases, applying knowledge of database management systems.
Want more jobs like this?
Get jobs in Jefferson City, MO delivered to your inbox every week.
- Support development teams with technical and physical design, development, and maintenance of z/OS DB2 databases; including data analysis and modeling, programming, implementation, performance monitoring, tuning, cloning/refreshing, planning, problem resolution, and data dictionary administration.
- Install, upgrade, and patch database software, agents, utilities, and options.
- Collaborate with development teams on use of standard practices for the design and implementation of databases to meet user application requirements.
- Maintain test tools for managing data base objects and diagnosing problems. Evaluate and test new versions, as well as third party vendor utilities and reporting tools.
- Execute test and audit strategies for backup, security, and disaster recovery of Databases and other systems
- Position requires 24/7 support rotation for on-call support.
Long Description
Experience:
- Experience must include creating/evaluating/documenting logical and physical data models, developing stored procedures/triggers/scripts/SQL and optimizing/tuning SQL in production and development/test environments.
- 7 years' experience in logical design and physical design,
- Experience with data modeling using ERSTUDIO
- 7 years demonstrated experience leading efficiency improvements and implementation of DB policies and procedures.
- 7 years' experience in DB2 z/OS database administration tasks including database object creation, security, performance tuning, utilities, and backup and recovery.
- MAINFRAME SKILLS DESIRED
- 3 years application design and 3 years COBOL, DB2, SQL, and JCL programming experience
- 3 years experience with CA DB2 Tools
- 3 years of VSAM File structure processing
- 3 years of TSO/ISPF/SDSF or equivalent products. One year can be
- Supplemented with an equivalent editor.
- Proficient in Microsoft Office; specifically, Excel, Word, or related products
- CICS, SAS, Syncsort, IBM Utilities, Easytrieve.
- Bachelor's or advanced degree in Computer Science Engineering, computer
- Information systems, management information systems, or a closely related field.
- Strong Knowledge of Agile methodology
- Strong Proactively collaborate with team members to design and implement elegant technical solutions.
- Testing programs or databases, correcting errors, and making necessary modifications
- Modifying existing databases and database management systems or directing programmers and analysts to make changes
- Planning, coordinating, and implementing security measures to safeguard information in computer files against accidental or unauthorized damage, modification, or disclosure
- Working as part of an IT project team to coordinate database development and determine project scope and limitations
- Writing and coding logical and physical database descriptions and specifying identifiers of database to management system or directing others in coding descriptions
Deliver
No.Performance ParameterMeasure1.Continuous Integration, Deployment & Monitoring of Software100% error free on boarding & implementation, throughput %, Adherence to the schedule/ release plan2.Quality & CSATOn-Time Delivery, Manage software, Troubleshoot queries, Customer experience, completion of assigned certifications for skill upgradation3.MIS & Reporting100% on time MIS & report generation
Expected annual pay for this role ranges from $60,000 to $1,35,000 . Based on the position, the role is also eligible for Wipro's standard benefits including a full range of medical and dental benefits options, disability insurance, paid time off (inclusive of sick leave), other paid and unpaid leave options.
Reinvent your world. We are building a modern Wipro. We are an end-to-end digital transformation partner with the boldest ambitions. To realize them, we need people inspired by reinvention. Of yourself, your career, and your skills. We want to see the constant evolution of our business and our industry. It has always been in our DNA - as the world around us changes, so do we. Join a business powered by purpose and a place that empowers you to design your own reinvention. Come to Wipro. Realize your ambitions. Applications from people with disabilities are explicitly welcome.
If you encounter any suspicious mail, advertisements, or persons who offer jobs at Wipro, please email us at helpdesk.recruitment@wipro.com. Do not email your resume to this ID as it is not monitored for resumes and career applications.
Any complaints or concerns regarding unethical/unfair hiring practices should be directed to our Ombuds Group at ombuds.person@wipro.com.
We are an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, caste, creed, religion, gender, marital status, age, ethnic and national origin, gender identity, gender expression, sexual orientation, political orientation, disability status, protected veteran status, or any other characteristic protected by law.
Wipro is committed to creating an accessible, supportive, and inclusive workplace. Reasonable accommodation will be provided to all applicants including persons with disabilities, throughout the recruitment and selection process. Accommodations must be communicated in advance of the application, where possible, and will be reviewed on an individual basis. Wipro provides equal opportunities to all and values diversity.