Database Administrator Customer Care

SAMRITA SRIVASTAVA

Phone: 404-***-**** Email: ********@*****.***

About Me

I am an experienced IT professional with over 18 years of database administration experience across various enterprise and open source database technologies. Having administered and managed highly visible and demanding environments and worked across multiple groups, I have excellent communication skills. I am self-motivated and I have worked with teams with varying levels of expertise, providing guidance where I can and learning at every opportunity. Having worked with projects in all stages, I have a very good understanding of the project lifecycle in IT from design to operations and I have contributed at every level. My experience will prove that I have the right knowledge, skillset and temperament to successfully administer, manage, automate and deliver any data environment irrespective of its complexity or size.

Strengths & Responsibilities

• Proven expertise in all aspects of database maintenance from design to maintenance.

• In-depth knowledge of relational database management systems.

• Domain knowledge and experience with retail and banking systems and applications.

• Expertise in maintaining highly demanding & transactional DBs including those used in e-commerce.

• Experience and expertise in administering very large and complex database systems.

• Installation, maintenance, support & tuning of various databases including DB2 UDB, MySQL, PostGres.

• Implement means to optimize system settings for efficient SQL executions.

• System monitoring and database capacity planning for ongoing tuning for performance.

• Proficiency in creating backups and recovery process and automating them.

• Automation of database monitoring and maintenance processes,.

• Expertise in setting up and administering security and integrity of all database environments.

• Contributed in all stages of a project lifecycle from design to support, with training and documentation.

Professional Experience

Lowes Home Improvement 02/2020- Present

Sr. Infrasturcuture Engineer

Provided database support for stores application.

DB2 Version upgrade from 10.5 to 11.5

Achieve optimal system settings for efficient SQL executions through superior knowledge of SQL.

Maintain high level environment for system support, planning, setting procedures, and providing technical supervision.

Ensure reliable and secure system for running business applications.

Resident expert providing technical consulting and performance analysis to application development groups.

Standardizing database design for DB2 and Postgres objects such as tables, schema, indexes, packages, procedures, functions, and triggers.

Installed and configured Postgres databases while designing new Microservices alongside the solution teams on Docker containers

Configured event monitors for capturing deadlocks and long running sqls.

Tuned long running SQL queries to achieve cost cutting.

Determining and Decommissioning servers for software Licensing requirements on DB2

Configured HADR for Lowes Stores online fulfillment center .

DICK’S SPORTING GOODS, Charlotte, NC 3/2016 – 2/2020

Infrastructure Database Administrator

• Infrastructure DBA for DSG.com IBM DB2 UDB purescale websphere commerce databases hosted on redhat linux servers.

• Inhouse migration of single node database to DB2 LUW purescale version10.5.6 for DSG and GG/F&S

• Provided infrastructure support for new Purescale db2 database environments for an immensely growing commerce db.

• Performance monitoring and fine-tuning of growing voluminous database for optimal performance of SQL queries.

• Implemented db2 luw database security guidelines and managed objects permissions for stored p rocedures, extended stored procedures, functions, and views for optimized for purescale.

• Automation of data refresh and data masking and scrubbing solutions for customer data.

• Implemented solutions for the reporting db for order retention/archival and reporting purposes.

• Rolling fixpack upgrade for purescale version db2 luw 10.5.6 to 10.5.9 one member at a time.

• Standardized database backups and restoration methodology.

• Optimized SQL statements for improved scalability and performance for holiday traffic.

• Implemented DR solutions with HADR for pure scale and non pure scale environments

• Implemented QREPLICATION solution for purescale as order retention and archival purposes

• Ran deadlock reports to troubleshoot customer data load issues for mysql customer care.

• Problem determination including CPU/IO utilization using Unix/Linux commands for MySQL

databases for DSG’s customer care app.

BANK OF AMERICA, Charlotte, NC 8/2015 – 3/2016

Database Administrator

• Managed 16 terabytes of data for development, staging and product of data mart for BACARDI systems.

• Supported decision support and BIG DATA system for data warehousing environment.

• Formulated load strategies and performed load testing, backup, and recovery processes.

• Fine tuned and validated SQL queries for performance.

• POC for Hadoop Cloudera.

• Admin for DB2 LUW and Vertica dbs, management of filesystems and monitoring.

SAMRITA SRIVASTAVA, Page 2

LOWES HOME IMPROVEMENT, Charlotte, NC 9/2012 –8/2015

Infrastructure Database Administrator

• Provided Infrastructure database support to lowes.com IBM DB2 LUW databases for websphere commerce application.

• Standardizing database design for DB2 objects such as tables, schema, indexes, packages, procedures, functions, and triggers.

• Installed and configured DB2 UDB databases and created the logical and physical design.

• Achieve optimal system settings for efficient SQL executions through superior knowledge of SQL.

• Maintain high level environment for system support, planning, setting procedures, and providing technical supervision.

• Ensure reliable and secure system for running business applications.

• Resident expert providing technical consulting and performance analysis to application development groups.

• Determined and Implemented technical database solutions for small critical applications and ticketing system as a part of which designed and Installed Postgres Databases for Atlassian suite

• Installed and configured Cassandra db for Store card service systems.

• POC for DB2 UDB Purescale implementation on IBM Puredata systems.

CITIZENS PROPERTY INSURANCE, Tallahassee, FL 8/2010 – 8/2012

Database Analyst

• Researched and interacted with business unit personnel to collect and document data ownership, data classifications, and data definitions.

• Created, analyzed, and maintained spreadsheets, team production, databases and reports for measurement, monitoring, and managing results of projects.

• Demonstrated ability to solve problems through analytical approaches.

• Collaborated with business unites to evaluate processes and identify system function enhancements.

• Utilized business systems and database tools to compile statistical data and prepare various reports.

• Managed database design phase during development.

• Supported multiple projects for the policy administration system for the application of work flow and design implementation of tablespaces, tables, views, indexes, triggers, and securities into development and QA.

• Created, maintained, and implemented DB2 stored procedures and triggers.

• Performed SQL monitoring for nightly cycles and uploads.

• Created installation and procedural documents for support staff.

VERIZON DATA SERVICES, Tampa, FL 11/2009 –7/ 2010

Database Administrator

• Infrastucture design, analysis and management of DB2 LUW database on AIX platforms

Technical advice on performance monitoring, problem identification, and resolution.

• Tune and maintain technical integrity and monitoring of the operational efficiency of application databases in support of internal and external customers.

• Managed 20+ DB2 UDB database servers from 20 GB servers to a 2 TB in OLTP and data warehouse environment.

• Performed data migration for DB2 LUW databases from Verizon servers to frontier servers, using EXPORT, IMPORT, and DB2move utility, utilizing copy/delete methodologies to migrate data.

• Supported mission critical production databases for 24/7 monitoring, performing diagnoses and troubleshooting.

SAMRITA SRIVASTAVA, Page 3

UCSD, San Diego, CA 4/2009 – 10/2009

Database Administrator

• Developed database for web application project for hospitals to retrieve billing records over the internet.

• Technical resource for extracting, transforming and loading between data sources.

• Led application team in developing beta software.

• Designed new features and validated all new development.

• Determined strategies to extract data from different sources with complex sequel queries.

• Supported the design, analysis, and management of database solutions with performance emphasis.

• Organized and aggregated clinical data across multiple sources by configuring Mirth open source clinical data repository.

VERIZON BUSINESS, Colorado Springs, CO 8/2006 – 8/2008

Database Administrator

• Installed and configured database server product (DB2 UDB), performed fixpak upgrades, and applied current patches, and was responsible for backups and restores.

• Supported clustering and replication for DB2 LUW servers and the migration of DB2 UDB Databases

• Perform capacity planning, performance tuning and benchmark testing; monitoring SQL uptime.

• Designed and populated reporting tables, views and stored procedures; configured partitioning for tables with over 300 million rows. (Provide 7 X 24 Support-mission critical DB’s)

• Implemented and maintained database security guidelines and setup permissions.

• Migrated Tablespace containers from raw logical volumes to DMS containers.

• Created federated data sources from DB2 to Oracle databases.

Education & Training

Master of Science, Georgia State University, Atlanta, GA

Technology Summary

Database Systems

IBM DB2 UDB, MySQL, PostGres, SQL Server, MS Access, Excel.

GUI based DB Tools

DB2 Quest Central, DB2PE, MySQL Workbench, Aquadata Studio.

Operating Systems

AIX, RedHat Enterprise Linux, Solaris, Windows Server, SCO-UNIX, MS-DOS.

Scripting Languages

Shell scripting (BASH, KSH), PERL, PL-SQL.

Contact this candidate