Summary
Overview
Work History
Education
Skills
Timeline
Generic

Prasanta Behera

Bothell,Washington

Summary

High-performing professional with extensive experience managing large-scale, complex databases. Skilled in SQL and database management systems. Strong understanding of database design and data modeling with excellent troubleshooting skills. Smart and committed to staying up-to-date with new technologies and advancements.

Hands on Database Administrator focused on supporting large scale mysql, Oracle , AWS, RDS, Aurora Mysql and databases systems. Expert in mysql with 20+ years of
experience Motivated and detailed with unsurpassed abilities in database architecture, teamwork and crafting of high-quality database solutions.

Experience in mysql installations, monitor and improve performance of the databases, take backup/restore of databases, upgrade database to higher version to fix the bugs, converting mysql databases from classic to innodb and cluster sets, troubleshoot and fixed production database issues, TDE implementations, finding and resolving security violations in databases.

Experience in installation and upgrade of mysql databases,xtrabackup, mysqlshell ranging from 8.0.13,8.0.22,8.0.27,8.0.28,8.0.31, 8.0.33

Experience in client-server and 3-tier systems performing ORACLE 7.x.x/8.0.5/8i/9i/10G/11g/12C installation/migration,
Oracle RAC install/maintenance, design, database replication, performance monitoring,Tuning, formulating backup/recovery
strategies in hot backup/cold backup/RMAN/export/imports,Oracle Application Express install and maintenance, Onames Server config,
Net8 network config/maintenance etc. Administer RHEL Solaris Operating system on a Sun Sparc environment.

Overview

22
22
years of professional experience

Work History

Principal Database Administrator

T-Mobile
10.2018 - Current
  • Support 40 large production Percona Servers running versions 8.0.27, 8.0.31, 8.0.33 and Aurora Mysql databases on 24x7 basis.
  • Upgrade mysql databases from 8.0.22 to 8.0.31 and Aurora mysql databases from 3.01.0 to 3.03.2
  • Identify and solve various database related issues using variety of diagnostic tools, such as Promethus using mysql exporter, node exporter and vmstat.
  • Define and document database best practices.
  • Administered, supported, and monitored databases by proactively resolving database issues and maintaining servers.
  • Created and implemented database designs and data models.
  • Developed scripts and processes for data integration and maintenance.
  • Wrote and maintained technical and functional specifications to document database intentions and requirements.
  • Proactively monitor activity, utilization, exceptions and database health to identify areas of improvement.
  • Use scripting languages, such as shell and bash to automate various repetitive maintenance tasks.
  • Review and analyze all proposed SQL and schema changes prior to deployment to production environments.

Principal Oracle Database Administrator

T-Mobile
11.2007 - 10.2018
  • Design, Implement, Administers and Monitor Oracle databases Management Systems across the Organization.
  • Managing the database availability and performance including incident and problem management. Managing database security issues and audit trails.
  • Served as a team lead and technical escalation point for business impacting issues related to database technologies.
  • Created and updated database designs and data models.
  • Set up and controlled user access levels across databases to protect important data.
  • Tuned and optimized queries for optimal performance.
  • Established standards for all MySQL database environments based on MySQL best practices. Initiative involved redesigning all new and legacy environments to adhere to these newly established standards.

Senior Database Administrator

T-Mobile
Seattle, WA
12.2001 - 10.2007
  • Provided operational support for Oracle and MySQL environments.
  • Owned, tracked and resolved database related incidents and requests.
  • Developed and maintained installation, backup, maintenance and other database related scripts.
  • Proactively and reactively monitor database performance as well as backups and maintenance processes.
  • Provided 24x7 on call support for database related issues; MySQL and Oracle
  • Involved with HIPAA, SOX, PCI and PII audits.
  • Defined database management policies and procedures.
  • Established monthly DBA/Developer brown bag to meet and discuss trends and issues with MySQL.
  • Developed shell scripts to auto generate passwords for database users that could be shared securely with other databases on other servers; remote and local.

Education

Master of Science - Computer Application

National Institute of Technology
Rourkela, India
06.1986

Skills

  • Application/database design
  • Nosql and Relational database design and development
  • Database management
  • Documentation on Database Design and Objects
  • Database Backup and Recovery, performance
  • improvements, Capacity Planning and Documentation
  • Shell scripts to support Database Administration and Support activities
  • Index Analysis, Tuning and Maintenance

Timeline

Principal Database Administrator

T-Mobile
10.2018 - Current

Principal Oracle Database Administrator

T-Mobile
11.2007 - 10.2018

Senior Database Administrator

T-Mobile
12.2001 - 10.2007

Master of Science - Computer Application

National Institute of Technology

Similar Profiles

CREATE PROFILE
Prasanta Behera