| | | 20,000+ Fresh Resumes Monthly | |
|
|
| | Related Resumes Data Engineer Senior Raleigh, NC Senior Cloud Engineer Liberty, NC Senior Network Engineer Durham, NC Senior App. Development Engineer Cary, NC Sr. Recruiter - Energy, Infrastructure, Engineering, Manufacturi Raleigh, NC Test QA Engineer Senior Software Durham, NC Senior Quality Engineer / Scrum Master Apex, NC |
|
Click here or scroll down to respond to this candidateCandidate's Name
Street Address Haybeck lnApex NCStreet Address
Mobile:PHONE NUMBER AVAILABLE Email:EMAIL AVAILABLEIBM-Certified DB2 DBA in LUWDesignation: Senior Principal Infrastructure Engineer/Advisor at TRUIST Bank (SAP DB2 & HANA, UDB, MySQL, Cassandra, POSTGRESQL, MongoDB)Professional Summary: -16 years of total IT Experience with 14 years experience on DB2 UDB & SAP Database Administration and 6 years experience on MySQL, Netezza and 2 years in POSTGRESQL Databases Administration, MongoDB, and CassandraBuild the databases systems from scratch and configure the system as per application requirements.Perform various types of steps to resolve the slow query/application performance issueWork with various application teams from different distributed databases and understand to tune the database according to their business modelTraining a bunch of TNTs on a timely manner to adapt the new technologies in our teamComplete knowledge in setting MySQL Innodb cluster setup for new systems/applications.HADR with TSA Implementation in production environmentExperience with Multi standby HADR nodes configurationExperience on DB2 BlueHands-on in shell scripting & Query tuningWrote the commands for DR activity steps across DB2, MySQL and POSTGRESSQL EnvironmentsExperience with Optim Performance Manager implementation in production serverStarted working with IBM data server Manager (A next generation tool from IBM)Hands on Tools like MySQL workbench, IBM Netezza Admin, MySQL performance Monitor and HPDMA, Rubricks etcExperience in setting up Adaptive Compression.Experience in writing Database Health Check reports scriptsExperience with Upgrading and downgrading TSA cluster online from lower to High versionWorked on multiple DB2 Version upgrades on Critical LandscapesPerformed Performance Tuning for production database serverExperience with database troubleshootingPreparation of Project documents, implementation plan & change gridsRecommendation on Hardware & capacity planning for database serverParticipation in DR planning and ImplementationExperience in handling the team as a leadSoftware Details:-DB2 Version 11.5,11.1, 10.5, 10.1, 9.7, 9.5, 9.1, 8.1MySQL version 5.7 8.0Apache Cassandra 4.1MongoDB 7.0 and 6PostgreSQL Version 9.6 and 12IBM Netezza Versions 7.**AIX Version 5.3, 6.1, 7.1, 7.3Suse Linux 10.1, 11.1, 11.3Redhat Linux - 5.1, 6.4, 7.2Windows XP, 2000, 2003, 2007, 2010Education:-Masters in Computer Applications (MCA) :- From S.V University, Tirupathi in the year 2008 with 78%BSC Computers :- Graduated From Mother Theresa Degree College, Palamaner in 2005 with 90% marks securedProfessional Experience:-BB&T Corporation Jun 2015 - CurrentProject: BB&T Database SystemsRole: Database ConsultantEnvironment: DB2 UDB & SAP/HANA/MySQL/Netezza/Sql Server/AIX/Linux/zLinuxPeriod : June 2015 till dateURLs: http://www.bbt.com/BB&T Corporation is a bank holding company based in Winston-Salem, NC. its bank operates 2049 branches in 15 states and Washington, D.C, and offers consumer and commercial banking, securities brokerage, asset management, mortgage and insurance products and services.I am currently working as a database consultant handling majorly DB2 SAP, UDB and MySQL systems. I also manage IBM Netezza and Sql server systems too.Roles & Responsibilities -Supporting close to 4000 databases servers across multiple database environmentsPerform end to end database operation activities across platformsMigrating databases and installing Fix Pack and special builds bases on requirementsPerform DR test activities across the environmentsWorks closely with applications team and suggest them a lot in terms of query performance and tuningworks closely with vendors on any special builds or bugs in vendor softwarewrote scripts to generate the database stats on corporate portals for Top Management's convenient viewPlay around with HA in new environments and also automating it with TSA.Perform different backup and restore scenarios with minimal downtime using different storage mediums.Wrote scripts to automate the database maintenance activities like Reorg and Runstats.Gave Demos in lot of Tech talk meetings across platformsWork on capacity planning, database layout and designing. Handle performance issues related to SQL queries and database configurationWipro Technologies Sep 2012 - Jun 2015Project: Cardinal Health, NARole: Lead Database Administrator/DB Architect, PLEnvironment: DB2 UDB V9.7/10.1/V10.5 /AIX/Linux/zLinux & NTPeriod : Sep 2012 till dateURLs: http://www.cardinalhealth.com/Cardinal Health, Inc. is a Fortune 500 healthcare services company based in Dublin, Ohio. The firm specializes in distribution of pharmaceuticals and medical products, serving more than 60,000 locations. The firm also manufactures medical and surgical products, including gloves, surgical apparel and fluid management products. In addition, it operates the nations largest network of radio pharmacies.Worked as a Lead DB2 UDB DBA at onsite handling both production & development databases and coordinating team at offshore.Roles & Responsibilities -Supporting around 1000 databases having 30 SAP Production and 100 non sap Production databasesBuild database servers both SAP and Non SAP from end to end that includes, installing DB2 binaries, Creating instance, creating database, configuring parameters and enabling Netbackup/Flash/clone/XIV copy backups.Migrating databases and installing Fixpack and special builds bases on requirementsHandling both Run work and Project worksUnderstanding the requirement from Application owners, Preparing an Tech document on same and delegating the work to OffshoreShift, handling escalation, managing timesheet, recruiting and grooming new resources.Managing and administering the production and development databases on multiple servers.Setting up HADR in new environments and also automating it with TSA.Flash restore of databases.Verify alert mails like backup status, percentage usage of tablespaces, missing permissions, etc.Daily basis health checkup of production databases like checking diagnostic, notify logs, etc.Interacting with clients, attending workshops to solve their issues.Work on capacity planning, database layout and designing. Handle performance issues related to SQL queries and database configurationCognizant Technology Solutions May 2010 - Sep 2012Project: STAPLES IncRole Sr Database Administrator (Sr System Executive)Roles and Responsibilities:Supporting around 150 servers and 250 databases across staples environment.Developing small shell scripts for various automationClosely working with IBM experts on PMRsMaintaining Database Level (DB CFG) and Database Manager Level (Instance) Parameters.Installation and configuration of DB2 server on AIXCreation of instances and databasesCreation of various DB2 objects like tables, schema etc.Creation off Bufferpool and tablespacesUsing the utilities to export import and load the dataGranting and revoking the rights on DB objects to different usersUpgrading the DB2 server from a lower versionApplying the Fix Pack to DB2 systemResponsible for executing Runstats, Reorghchk and Reorg on tables and indexes and Rebinding of ProceduresWorking with DB2ADVIS and DB2EXPLAIN to monitor the performance issuesMonitoring the db2 systems using snapshot and Event monitors and DB2TOPScheduling the backups using Cronjob and task schedules on AIX,LINUXResponsible for taking Full online, Full offline,incremental and Delta backups according to the requirementRestoration of backups using full backups as well as Incremental backupsRedirect restoration of backups from source server to destination serversMaintain the Tablespaces and altering the tablespaces to add or extend the containersTaking the DB2LOOK of database and objectsCataloging the databasesProviding the support to development teams for enhancing the query performanceHands on DB2 tools like Toad, Developer Workbench, Control Center and OPMSQL ReplicationTable Movement using Admin tab move function in db2 V9.7Table compressionReclaiming space from HWMMonitoring scheduled Jobs, deadlocks, analyzing long running processesTTK Services June 2008 May 2010Project Healthcare ManagementRole Database Administrator (Remote Executive Analyst)Roles and Responsibilities:Supporting around 100 databases across the TTK health services environment.Configuring and tuning Database and Database Manager Level Parameters.Installation DB2 Software on Window and Linux serversCreation of instances and databasesCreation of DB2 objects like tables, schema, indexes, views, aliases etc.Using the utilities to export import and load the dataGranting and revoking the rights on DB objects to different usersUpgrading the DB2 server from a lower versionMonitoring the db2 systems using snapshot and Event monitors and DB2TOPScheduling the backups using Cronjob and task schedules on AIX,LINUXResponsible for taking Full online, Full offline,incremental and Delta backups according to the requirementRestoration of backups using full backups as well as Incremental backupsRedirect restoration of backups from source server to destination serversGET FRIDAY June 2006 June2008Project - Pivotal ManagementRole Software ExecutiveRoles and Responsibilities:Monitoring the Db2 file system usages and alerting the customer on space addition and clean upInstallation and Maintaining the Pivotal Tool and database locallyCreating tables and indexes as required.Scheduling backups and alerts for servers on cronPerforming maintenance task like Reorg and runstatsForcing the applications as per as requested by AppsWorking on L1 and L2 level tasksMonitoring scheduled Jobs, deadlocks, analyzing long running processesProfessional Certification:IBM certified DB2 UDB DBA-IBM: Test 000-730: DB2 9 Family FundamentalsIBM: Test 000-731: DB2 9 DBA for Linux UNIX and Windows |
