|
|
|
|
| Desired Industry: Information Technology |
SpiderID: 21310 |
| Desired Job Location: Morristown, New Jersey |
Date Posted: 6/16/2008 |
| Type of Position: Full-Time Temporary |
Availability Date: |
| Desired Wage: |
|
|
U.S. Work Authorization: |
| Job Level: Experienced with over 2 years experience |
Willing to Travel: |
| Highest Degree Attained: |
Willing to Relocate: |
Objective:
Summary:
A Certified Database Administrator specializing in IBM DB2 UDB with overall 5.5 years experience in various aspects of DB2 UDB including physical and logical design, performance monitoring, maintenance, query analysis, optimization, backup and recovery, replication and migration.
Excellent communication, interpersonal, technical skills and can easily adapt to new environments.
Proven excellence to work in a team in achieving common objectives along with personal ones.
Installation of DB2 UDB EE and Fixpacks on UNIX and Windows machines.
Design, Creation and maintenance of databases for highly demanding environments.
Replication and Migration of databases across heterogeneous platforms.
Performance tuning of databases including query tuning and optimization.
Understanding of database access and ability to assist developers in implementing efficient SQL code.
Establish standards, controls, and procedures to ensure data integrity and security.
Developing strategies to manage large data volume growth of Enterprise Data warehouse.
Backup and Recovery of databases and High Availability Disaster recovery (HADR).
Determine and provide assistance with the methods used to format, load or update data
Writing UNIX shell scripts and PERL scripts.
Provide 24X7 production support, problem resolution and recovery processes during an outage resolution.
Certifications:
IBM Certified Database Associate DB2 Universal Database V 8.1 Family
IBM Certified Database Administrator DB2 UDB V 8.1 for Linux, UNIX and Windows
Experience:
Oct 06 - Present Bank of America, New York, NY
DB2 UDB DBA
Bank of Americas is the largest commercial bank in USA providing banking and non-banking financial services and products both domestically and internationally.
Responsibilities:
Perform database maintenance activities such as backup, reorg, runstats.
Install and configure DB2 UDB new releases, upgrades, and patches.
Scripting, design/analysis, installation, monitoring, maintaining, troubleshooting, and tuning UDB databases
Analyze DB2 UDB Event Monitor information, physical design, performance characteristics of tablespaces, physical I/O rates, and table access activities.
Proactively monitor performance, diagnose problems and tune queries and database.
Assisting with the creation and modification of primary database storage structures (tablespaces) and primary objects (tables, views, indexes)
Implement data security guidelines while making data available to those authorized to have access
Create and maintain documentation such as Functional design documents, detailed design documents, data flow diagrams, data entity relationships documents for all the internal projects.
Interface with business analysts & developers with regards to application, logical & physical database design, create and maintain logical entity relationship diagrams, transform logical models into physical data models.
Changing instance level and database level configuration parameters for database concurrency, authentication, performance and allowing remote clients accessing server.
Provide 24X7 on-call support to troubleshoot issues with the Production schedule.
Perform capacity planning and analysis and implement required changes on the database server
Environment:
Hardware : IBM and SUN machines
O/S : AIX 5.2 and 5.3, SUN OS 5.8
Environment : DB2 V8.1/8.2, DB2 V9.1
Tools : Foglight and Quest Central
June 05 Oct 06 MetLife Insurance, Somerset, NJ
DB2 UDB DBA
MetLife, Inc., through its subsidiaries, provides insurance and other financial services in the United States and other countries. It offers life insurance, annuities, automobile and homeowners insurance, and retail banking services to individuals; and group insurance, reinsurance, and retirement and savings products and services to corporations and other institutions.
Responsibilities:
Development, performance monitoring and tuning for UDB 8.1/8.2 versions
Migration of UDB V8.1 databases from p690 to new p595, AIX V5.3, machines.
Provide onsite support for all database administration work that has been handed over to offshore team.
Perform database software installations including and database creation and configuration.
Database Backup/Recovery of databases, including Redirected Restore.
Implement a library of homegrown scripts to automate the scheduling and notification of periodic maintenance jobs, including REORG, BACKUP, RUNSTATS, LOAD, IMPORT, etc.
Monitor DB2 UDB processes and logs for any anomalies, provide corrective actions.
Provide assistance to the development team on performance tuning, resolving locking solutions, assist data modeler with SQL scripts
Implement and test HADR performance for production environments..
Analyze application SQL for performance improvement opportunities and work with DB2 support on problems and questions.
Taking Snapshots and gathering other information related to the database and the system during stress tests or performance tuning.
24X7 on-call support and problem resolution.
Environment:
Hardware : IBM and SUN machines
O/S : AIX 5.2 and 5.3, SUN OS 5.8 and Windows Server 2003
Environment : DB2 V8.1/8.2
Tools : Quest Central, BMC Patrol, JS Console and Visual Explain.
Aug 04 May 05 Loud Cloud Inc. Austin TX
Education:
Aug 04 May 05 Loud Cloud Inc. Austin TX
DB2 UDB DBA
Opsware Inc., formerly Loudcloud, is the leading provider of data center automation software, offering a complete range of solutions for enterprises, government agencies and service providers. Working as DB2 UDB administrator; supporting a DSS database system for mortgage application.
Responsibilities:
Responsible for application SQL Query tuning, database parameter tuning, operating system tuning, memory tuning.
Database Backup/Recovery on databases and file system backups. Redirect Restore to move application from Development, QA and Production
Advise Business Systems Analysts, technical managers and business users to help them define business requirements and objectives in the implementation of specific area advanced technologies.
Analyze past trends and make suggestions to meet future requirements with respect to capacity and performance.
Use tools like db2advise, db2look, db2move and db2adutl to monitor, analyze and make changes in the database.
Analyze SQL queries using Visual explain and make recommendations to application developers for performance issues.
Migrate and/or coordinate the migration of application systems from test (for quality assurance) to production environments.
Conduct performance analysis on application SQL code and assist in troubleshooting by providing solutions or directions that are consistent and effective.
Plan and implement disaster recovery and standard recovery testing using established documentation
Be ON CALL and provide maintenance support for the production databases
Create a bug tracking system which would keep track of all bugs detected and their status, that whether they were solved or not
Create a library of scripts to carry out every task that was essential.
Database design, customisation and administration of Websphere provided tables.
Environment:
Hardware : IBM machines
O/S : AIX 4.3/5.2 and Windows 2000
Environment : DB2 V8.1
Tools : Design advisor, Erwin, DB Artisan, Quest Central, BMC Patrol
Jan 03 Aug 04 Fidelity Information Systems Company India Pvt Ltd, Bangalore India
DB2 DBA
Fidelity Information Systems Company India Pvt Ltd offers technology-based solutions to financial companies in India. It is a US based company having offshore centers in India at Bangalore and New Delhi
Responsibilities:
Writing Shell and PERL scripts to automate routine maintenance jobs such as backup and runstats.
Taking snapshots and creating event monitors for gathering necessary data
Providing support for maintenance of test database including backup and recovery
Maintenance of objects (Tables, Table spaces, Schemas, Indexes, views, Packages)
Providing technical expertise in infrastructure platform support throughout all phases of break-fix (problem identification, resolution, test, deployment, and turnover)
Serve as primary contact between the application teams and IT support groups (DBA, Middleware, Application Change Control, etc.)
Develop user interface for the project in Visual Basic and also written programs for converting Console generated text files to Access database in Visual Basic.
Working on the proposed database design, development, and creation of all file system layouts, database environments, referential integrity relationships/constraints, security environment roles, etc
Turnover stored procedures and rebind them as needed to support implementations
Experience in writing and running self-security-monitoring shell scripts to ensure that right authorities and privileges assigned on users.
Environment:
Hardware : IBM RS/6000 and IBM ES/9000
O/S : AIX V4.3 and Windows 2000
Environment : DB2 V7.2
Tools : Quest central and Erwin
Skills:
Skill:
Operating Systems : Linux (Redhat, SuSe), AIX 5L, SUN Solaris, HP/UX and
Windows (2000, 2003,NT).
Hardware : IBM RS/6000 SP, IBM ES/9000, IBM 3090, IBM PCs, MS IIS, and Storage
Area Network (SAN) EMC/DMX, Tivoli Storage Manager.
Database Tools : BMC Patrol, Quest Central for DB2, DB Artisan, Control Center,
Visual Explain, Erwin, Foglight Quest Data Factory.
Web Servers : IBM Websphere, Weblogic
Software Packages : Lotus Notes, MS Office XP, MS Visio, Rational Rose
Candidate Contact Information:
| Name: Kaushik Nagaraj |
|
| Street: - |
Phone: 973-841-2212 |
| City: Morristown |
Fax: - |
| State: New Jersey |
|
| Zip: |
|
| Web Site: |
|
|
|
|
|
|