| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Email : EMAIL AVAILABLEOBJECTIVE:Result-oriented DBA with over 15+ years of experience and 3 years in Cloud Platform working in leading Manufacturing,Healthcare, retail and Insurance organizations, seeking a position in a challenging and fast-paced environment to service effectively for the growth of the organization.Professional Summary:Expertise in installation/Fixpacks/Upgrades of the DB2 LUW softwares(10.X/11.X/11.5) and creation of the instances and databases and other DB objects.Worked for various DB2 LUW Server builds and database design involving IIS, Datastage,Netcool, DSM/DMC,Ecommerce websphere,Tririga repository databases setup for SUSE/AIX environments and participate in end-end application setup.Expertise in managing big scale DB migration of the DB2 ZOS to DB2 LUW and DB2 AIX to SUSE vice versa.Expertise in playing the critical lead role with onshore/offshore team for Data center migrations of DB2 LUW databases in AIX/SUSE involving with minimal downtime strategies for different DB2 LUW versions and High availability databases.Extensively worked with Backup and Recovery Strategies using the TSM, veritas netbackups and support for fixing the long running backup latencies and troubleshooting backup failures maintaining the recovery SLA.Performance tuning with Indexes, bufferpools and database configuration tuning and tune queries to avoid memory and CPU bottlenecks.Worked/implemented DB2 features compression, partitioning, High Availability solutions (HADR), Multiple Read only HADR and storage mirroring.Expertise in supporting disaster recovery testing for BCP and troubleshoot the connectivity issues.Expertise in coordinating with design/configure/implement in-memory/custom alert monitoring setup with auto ticketing tool using DMC,Dynatrace,Grafana tools in ON PREM/GCP Cloud environment.Automate the database activities to trigger the database critical events with autotickets for monitoring critical databases.Extensively supported the Db2 environments with High availability on Powerha,TSAMP and SQL,Attuinity CDC Replication for DB migrations from ON PREM, GCP.Support for design/testing to automate DB2 LUW provisions with habitat packages and perform end to end testing for the blue prints.Extensive support and coordination with multiple infrastructure teams in resolving critical/escalated issues with performances and various infrastructure deployments/patching/upgrade .2+ years of Experience in Provision of Postgres on GCP with terraform modules, assist application teams with Migration of on prem to Cloud,Postgresql,participate in POC for CLoudsql Postgress Upgrades, configure HA and replica and test failovers, enable CMEK,SSL on postgress databases and with Alloydb..2+ years of Experience in using mongodb on openshift containers and GCP. Build and Monitoring mongo databases from ops manager and Mongo Atlas and awareness on mongo tools (compass,mongoshell,mongocli,mongodump etc)Exposure to Deploy,configure,upgrade,decom,administer. the mongodb/postgres databases in openshift CAAS ensuring optimal performance,scalability and security.3+years of Experience in performing admin tasks for sql server databases with ALWAYS ON, linked objects, backup and restore using SSMS, migration of the databases from Sql server to DB2 and oracle to DB2 using the Data Transformation Tool.Having knowledge with working on Git,Github,Dockers,Kubernetes and openshift, terraform,Ansible,Jenkins for deployments and patching.Exposure to Amazon Web Services like RDS DB2 LUW, PostgreSQL,Aurora, Redshift,DynamoDB, Lambda, IAM, EC2,EFS, S3 Bucket, Glacier, Cloud Watch, managing security groups, VPC, Route53.Incident and Problem ManagementExpertise on Production and Maintenance environment with 24/7 supportManage team and Mentored multiple DBAS to be onboarded and comfortable with day 2 operations.Proven interpersonal, communication, problem solving skills and technical analysis.Certifications :Google Certified Database EngineerIBM DB2 LUW ADVANCE DATABASE ADMINISTRATOR.Academic Qualifications:M.C.A from Osmana University with distinctionTECHNICAL SKILLS:DBMSCloud PlatformCAASIBM DB2 UDB,Postgres,,Sql Server,Mongo.GCP /AWSKubernetes & Openshift containers.Data ModellingERWin3.5/4.1, Power DesignerETL ToolsInformatica,DatastageOperating SystemAIX,Linux Red Hat,Suse,windows,UNIXHardware & Backup SystemTSM, Netbackup,HACMP,TSA,POWERHA,GSLBScriptingPerl,shell,pythonTools/UtilitiesDevopsToad 4.3,DB2 Data Studio, DMC,SSMS,Optim,Mongo ops manager,PGadmin4,openshift, Ibm Performance Expert,Spotlight, Embarcadero,DBArtisan, AQT, Quest Central for DB2 5.0,SQL * LOADER,DTS,Dba CockpitDockers,K8s,terraform,Ansible,JenkinsProject Experience:Client : FORD MOTOR COMPANY (April 2016 Till Date)Role : Senior DB2 UDB DBAEnvironment : DB2 11.X, Db2 10.x AIX,Linux.ResponsiblitiesSupport DB2 LUW database technology with installations/upgradations/migrations from V10.X to V11.X.Work in depth with AIX and SuSE Linux Operating Systems, including performing Shell/Perl Scripting for monitoring db2 databases.Support for various Server builds and database design involving IIS, Datastage,Netcool, DSM/DMC tool repository databases and SAP DB2 Environments.Configure the db2 luw alert monitoring setup using DMC/ shell scripts.Support databases using partitioning and Datacenter migrations to NGDC for DB2 LUW.Expertise in playing the critical role for analyzing, troubleshooting,proactively monitoring for one of the critical DB2 database migration from AIX to linux supporting CRM application.Perform Backup and Recovery including TSM backups and storage mirroring technologies.Troubleshoot end-to-end performance related issues involved with indexes,bufferpool, database performance and long running backup issues.Active participation involving troubleshooting /for RCA and fixing the permanent fix for the ongoing Database issues.Expertise in HADR setup between primary and standby servers on AIX on PowerHA,GSLB environmentsSupport for the disaster recovery testing using 3 Node architecture/ storage mirroring technology.Automate the database activities using the shell scripts and expertise in using the auto ticketing tools triggering critical database events after datacenter migrations .Support for the design of automation of DB2 LUW provisions with habitat packages and perform end to end testing for the blue prints.Extensive Support in DB2 LUW database migrations from linux to aix, mainframes to linux and windows to linux.Participate in Packaging to make executables for client softwares like PGADMIN/Mongo COMPASS tomake available in Ford software inventoryIncident and Problem Management using SMARTIT,BMC, IT CONNECT and UCMDB discovery.Extensive support and coordination with multiple teams in resolving critical/escalated issues with performances .Perform regular Security vulnerability assessments for DB2 LUW database servers to make sure databases are at compliance.Experience in using Postgres on GCP, Migration of on prem to Cloud,Upgrades in GCP,AWS configure HA and replica and use of PGADMIN.Experience in using mongodb on openshift containers and GCP. Monitoring mongo databases from ops manager and Mongo Atlas and awareness on mongo tools (compass,mongoshell,mongocli,mongodump etc)Experience in using sql server databases with ALWAYS ON, linked objects and backup and restoreExposure in provisioning Postgres/Mongo/sql server deployments through terraform in GCP,AWS.Coordinate with other infrastructure support organizations, including Server, Storage, Backup operations, application development and management teams for various deployments with expertise in proactive monitoring and resolving the issues.Provide on-call 24*7 support in rotation to work with ticketing system resolving high/critical incidents and work with change control systems to coordinate the changes with other infrastructure teams and scheduled database changesClient : North Western Mutual(April 2014 April 2016)Role : Senior DB2 UDB DBA .Environment : DB2 UDB 9.7. FP 9a,10,11,DB2 10.1, Db2 10.5 AIX,LinuxResponsiblitiesExperience in administration of the large DB2 databases around 10 terrabytesProactive tablespace management with reclaiming the unused spacesExperience in managing the setups and coordination with fixpack upgrades from Db2 9.7 FP9a to Db2 9.7.10 FP 6setup of the new servers builds with DB2 databases.Experience in troubleshooting skills of High Priority tickets and involving the Root cause analysis.Scheduling the cronjobs for backup, runstats and other DB maintenance activities in AIXExpertise in the refresh of prod to non prod servers.Extensively involved in Database tuning, query tuning of the sqls with CPU hikes .Expertise in troubleshooting DB2 job failures and providing resolutions.Expertise in Performance Tuning, Monitoring of DB2 database on Linux and AIX using DB2Expertise in breaking-down the DBA activities during sizing, assignment and distribution of work to team members, defining escalation procedures, severity levels, roles and responsibilities for the junior DBAsProvided 24x7 hours support for service requests and on-calls for DB2 related problems in production environment.Client : The Coca Cola Company, (June 2012 April 2014)Role : Senior DB2 UDB DBAEnvironment : DB2 UDB 9.7. FP 6,8,DB2 10.1,SAP, AIX,LinuxResponsiblitiesExperience in administration of the large SAP DB2 databases around 10 terrabytesProactive tablespace management with reclaiming the unused spaces.Experience in fixpack upgrades from Db2 9.7 FP4 to Db2 9.7 FP 6 and setup of the new servers builds with DB2 databases.Experience in troubleshooting skills of hanging of the databases due to TSM problems.Expertise in.Scheduling the cronjobs for backup, runstats and other DB maintenance activities in AIXExpertise in the restore of the point in time recovery of the databases.Expertise in troubleshooting DB2 job failures and providing resolutions.Expertise in Performance Tuning, Monitoring of DB2 database on Linux and AIX using DB2.Expertise in breaking-down the DBA activities during sizing, assignment and distribution of work to team members, defining escalation procedures, severity levels, roles and responsibilities for the junior DBAs.Provided 24x7 hours support for service requests and on-calls for DB2 related problems in production environment.Client : NYPD United States,New York ( Mar 2010 May 2012)Role : Senior DB2 UDB DBAEnvironment : DB2 UDB 9.7,AIX,Linux,Java,Servlets,Hibernate,Portal 6ResponsiblitiesExpertise in creating and using the federated objects like nicknames, user mappings etc.Expertise in database creation,Schema changes maintenance and database utilities such as LOAD, RUNSTATS, REORG, BACKUP etc on AIX environmentsScheduling the cronjobs for backup, runstats and other DB maintenance activities in AIXPlanning and Implementing Backup and Recovery Strategies of DB2 databases, Automate the backups using the TSM and veritas netbackups and troubleshoot the backup failures.Migrating the DB2 aix databases to Linux Db2 databases.Worked with DB2 Partitioned databases. Partitioning the table and adding and rolling out partitions, backup and restore of the partitioned databases.Monitoring the partitioned databasesExpertise in HADR setup between primary and standby servers on AIXExpertise in Performance Tuning, Monitoring of DB2 database on Linux and AIX using DB2 Performance Expert and Db2 WLM tools.WLM for monitoring and analyzing of the databases.Coordinating with the cognos team for the connectivity issues in configuring and enabling the cognos audit log databases.Providing support for year-end processing, annual purgeProvided 24x7 hours support for service requests and on-calls for DB2 related problems in production environment.Client : Horizon BCBSNJ, ( Sep 2006- Feb 2010)Role : Senior DB2 UDB DBAEnvironment : DB2 UDB 9.1,8.2,AIX,Linux,Windows,MSCS,Java,Servlets, PortalResponsiblitiesInvoled DB2 DBA Administration and application deployments.Scheduling Tasks through task center in Windows and cronjobs in AIX, Linux and notifying.Automote Backup, and worked with db2 utilities like reorg, runstats export, load and import .Applying the fixpacks / Installations.Worked with DB2 in MSCS Environment like creating instances and Migrating to the clustered instances,configuring the administration server(DAS) in the cluster environment,creation of the databases in the MSCS environment.Worked in migrating the db2 instances & databases from version 8.2 to version 9.5.Worked with DB2 Connect installation and configuring the Z/Os databases to access the data.Provided 24x7 hours onsite and offshore support for service requests and on-calls for DB2 related problems in production batch cycles.Mentored and provided training for junior DB2 DBAs and taking the offshore lead responsibilities to bring up the confidence in client and received appreciation mails.(Candidate's Name ) |
