PROFESSIONAL SUMMARY:

• 8+ years of Database administration and support experience in all phases of software development lifecycle.
• Expert in Installation, configuration and maintenance of MongoDB, IBM DB2/SQL Server/Oracle/MySQL server and related products.
• Skilled in database administration tasks like Relational DDL design, Maintaining Referential Integrity, indexing strategies, and SQL Query Troubleshooting Using DB2 UDB
• Experienced in handling DB2 UDB security, establishing Replication between servers, Capacity planning, Backup and Restore procedures, maintaining archival logs, Corruption and RecoveryManaging task level permissions
• Be responsible for providing day - to-day support and maintenance for all databases running
• Take lead in investigating potential problems and issues raised by users; this includes on-call support and offline assistance
• Have experience in migrating databases with zero downtime
• Solid understanding of Database technology - DB2 UDB Distributed databases (DPF)
• Extensive Database performance tuning experience
• Experience with Unix/Linux OS platform and Unix Shell scripting and automation
• Deep understanding of industry-standards, best enterprise-class practices for a large distributed/Singular database environments
• Monitor application events to proactively optimize system and application performance
• Work with the team to automate daily tasks, and to promote rapid response to recurrent issues
• Work with Inter-department teams to implement changes to production and environments to increase efficiency
• Experience with analytical programming using Python, HTML, CSS and JavaScript
• Be accountable for maintaining databases in compliance with established best practices and established baseline configurations
• Be accountable for daily backup and disaster recovery procedures
• Implemented HADR for high availability for db2 database environments
• Work in conjunction with other IT groups and company departments to understand functionality, scalability, performance, security, and integration requirements for all business needs
• Keep up to date with supporting application architectures and functionalities running in Linux/UNIX environments.
• Perform other duties and responsibilities as required by management from time to time
• Suggest improvements and seek additional training to maintain skills necessary to work with changing technologies
• Experience with Big Data, NoSQL database technologies such as Apache Cassandra, MongoDB, HBase, CouchBase, Matrix, etc.
• Experience in working with IBM PureScale.
• Installing, configuring and maintaining DB2 Purescale database on Linux on x86.
• Translating logical data models into physical database designs
• Proficient in clustering techniques, load balancing, indexes
• Experience in Monitoring, managing and resolving performance issues using Foglight, Tivoli
• Experience working in virtual environment using VMware and VirtualBox
• Update Run Books and Knowledge base.
• Developing database architecting that includes sizing, performance, scaling, tuning, backup, high availability and disaster recovery for DB2 Purescale to support implementation of Content Manager on x86 Linux.
• Demonstrated success in past roles where Data Modeling and DB2 PureScale implementation skills were utilized to ensure system functionality, security, reliability, and performance were delivered in-line with client expectations
• Excellent written and verbal communication skills.
• Hands on experience in data processing automation using python.
• Strong organizational skills and the ability to multitask; can set priorities and follow a timeline.

TECHNICAL SKILLS:

Databases: DB2 LUW V 8.x, 9.x,10.5,11& Oracle 12/11/10g, SQL Server, MongoDB 3.x, MySQL, Maria DB

Data tools: IBM Data studio 2.x, Quest Fog light 4.x, 5.x, Spotlight, Toad, db2pd, db2haicu, db2top, SQL Loader, EMC Networker, IBM TSM, DB2 Connect, BMC Change Manager, SQL Optimizer.

Operating Systems: AIX 6.x,5.x/4, Red Hat Linux 4.x, 5.x, Solaris 2.8/2.7/2.6, Windows Server 2008, NT 4.0, HP-UX10.2/11.0.

Programming: Java, Shell Scripting, PERL Scripting, AWK and SED.

Automations Tools: Cron, Autosys, Windows Scheduler, TWS, ServiceNow, BMC Remedy

PROFESSIONAL EXPERIENCE:

Confidential - New York

Database Administrator

Responsibilities:

• Designed DB2 LUW Systems on Linux Server for the Latest FTM portal.
• Worked with Architecture, Design, Network Support, Server teams.
• Provided 24x7 on call DBA support for production environment on rotation.
• Provided support for backup, recovery, replication, deployment and real time production troubleshooting DB2 UDB databases with DPF.
• Diagnosed database performance issues using performance monitors and various tuning techniques.
• Collaborated with Systems administrators on Linux/Unix/VM issues related to Databases.
• Developed Shell scripts for automation of routine activities.
• Configured and maintained High availability and clustering.
• Increased database performance by utilizing MySQL/MariaDB configuration changes, multiple instances and by upgrading hardware
• Supported data guard/Qrep replication.
• Helped in Migrating 40 Application databases to AWS cloud.
• Certified AWS associated Architect.
• Addressed database production problems, database connectivity issues and Disaster recovery
• Configured Tidal to schedule daily/weekly/monthly jobs including Backup, Data load, snapshots and run stats scripts
• As a member of Wealth Management Team, provided supervision and assistance in meeting compliance, and choosing appropriate products and solutions.

Confidential - Wisconsin

Database Administrator

Responsibilities:

• Installed, configured SQL Server 2005 and 2008 R2 in all environments.
• Involved in Analyzing and Upgrading SQL Server 2005 test servers to SQL Server 2008.
• Perform SQL Server service pack and Windows Service pack upgrades.
• Designed and implemented comprehensive Backup plan using SQL Server Maintenance Plan.
• Experienced in configuring log Shipping and Mirroring for SQL Server 2008 R2.
• Troubleshoot performance problems and fine-tuning of databases.
• Rebuilding the indexes at regular intervals for better performance.
• Checking Database Health by using DBCC Commands and DMVS
• Worked extensively in Query analyzer and profiler for tuning queries using variable for characteristics and query costs.
• Experience in design, development, and implementation of DB2 (LUW, and PureScale) in an enterprise environment.
• Experience in replacing both cluster caching facilities using a rolling upgrade technique which ensures DB2 pureScale instance will not experience an outage.
• Monitored and modified Performance using execution plans and Index tuning.
• Transferring the data (ETL) to Data warehouse by SQL Server 2008 Integration Services.
• Involved in trouble shooting databases for its performance and concurrency.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies.
• Designed and created databases, tables, views, store procedures and triggers.
• Updating database systems by reviewing, planning, testing and installing database security patches and service packs.
• Involved in capacity planning and monitoring data/log files size, growth and disk space.

Confidential, New York

Database Administrator

Responsibilities:

• Performed Knowledge Transfer to Offshore DBAs for Operations Support.
• Provided DB2 LUW support in Staging and Production environments.
• Worked with Architecture, Design, Network Support, Server teams.
• Provided 24x7 on call DBA support for production environment on rotation.
• Provided support for backup, recovery, replication, deployment and real time production troubleshooting on DB2 UDB databases with DPF.
• Diagnosed database performance issues using performance monitors and various tuning techniques.
• Collaborated with Systems administrators on Linux/Unix/VM issues related to Databases.
• Developed Shell/Perl scripts for automation of routine activities for LUW.
• Configured and maintained High availability and clustering.
• Increased database performance by utilizing MySQL/MariaDB configuration changes, multiple instances and by upgrading hardware
• Supported data guard replication.
• Addressed database production problems, database connectivity issues and Disaster recovery
• Configured TWS to schedule daily/weekly/monthly jobs including Backup, Data load, snapshots and runstats scripts
• As a member of Wealth Management Team, provided supervision and assistance in meeting compliance, and choosing appropriate products and solutions.

Environment: DB2 UDB, SQL Server, MySQL, MariaDB, LDAP, TSM storage, Linux, Windows.

Confidential, New York

Database Administrator

Responsibilities:

• Installed, configured, monitored and maintained DB2, MySQL and Oracle systems.
• Upgraded databases to latest version.
• Worked with Instance and database configuration parameters to automate tasks for logging, storage and disk management.
• Collaborated with teams to identify and resolve project issues and risks.
• Developed and tested storage strategies and disaster-recovery plan for operational database and delivered solution that guaranteed recovery performance and high availability.
• Performance Tuning on a daily basis for preventing issues and provided capacity planning using.
• Proactively used db2advis and db2explain plans to tune expensive SQL queries effecting performance.
• Audited databases for security breaches using DB2AUDIT.
• Configured AutoSys to schedule daily/weekly/monthly jobs including Backup, Size of tablespaces, snapshot and runstats scripts.
• Enhanced end users understanding of database systems by conducting pre-implementation workshops, training sessions and creating user-friendly training materials.

Confidential - Washington, DC

Database Administrator

Responsibilities:

• Reviewed project deliverables for completeness, quality and compliance with established project standards
• Upgraded databases to latest version.
• Worked with Instance and database configuration parameters to automate tasks for logging, storage and disk management.
• Collaborated with teams to identify and resolve project issues and risks.
• Developed and tested storage strategies and disaster-recovery plan for operational database and delivered solution that guaranteed recovery performance and high availability.
• Installed, configured, monitored and maintained DB2, MySQL and Oracle systems.
• Performance Tuning on a daily basis for preventing issues and provided capacity planning using MySQL Enterprise Monitor.
• Performed database migration fromMyISAM format to Innodb storageengine to increase performance and betterment of integrity constraints.
• Installing MongoDB any version on all platforms.
• Integration and Extraction on data from RDBMS to MongoDB using Pentaho Tool.
• MMS cloud backup management.
• Used of Mongo top utility, Mtools, MongoProc tool to analyze logs.
• Sharding Concepts.
• Replication Setup of MongoDB on any Platform.
• Backup and Restore using mongo dump, mongo export, mongo import.
• Proactively used db2advis and db2explain plans to tune expensive SQL queries effecting performance.
• Audited databases for security breaches using DB2AUDIT.
• Configured Control-M to schedule daily/weekly/monthly jobs including Backup, Size of tablespaces, snapshot and runstats scripts.
• Enhanced end users understanding of database systems by conducting pre-implementation workshops, training sessions and creating user-friendly training materials.

Environment: MySQL, MariaDB, DB2 UDB, MongoDB, Cassandra, Oracle, SQL Server, Hadoop, Linux, Solaris and AIX.

Confidential

Database Administrator

Responsibilities:

• Installed, Configured and maintained DB2 LUW server and related products.
• Handled 20 Database servers.
• Addressed day-to-day problems encountered on production, development and test database environment.
• Developed and implemented standards to create databases and related objects.
• Performed online and offline backups as well as wrote shell scripts and scheduled them.
• Monitored Database, Table spaces and its objects through Snapshots, Health Monitors with Quest Central tool.
• Configured Crontab to schedule regular maintenance jobs.
• Worked with Architecture, Design, Network Support, Server teams.
• Performed user access management and management of logins, aliases, and groups to the databases
• Granted and revoked permissions on database objects as required.