PROFILE:

• Accomplished Database Administrator with extensive knowledge and proficiency in database administration.
• Adept performing various DBA services and across a multitude of platforms (LINUX, UNIX, Solaris and Windows) in production, development and test environments to ensure date integrity.
• Ability to communicate effectively with cross functional teams and work well in a dynamic fast paced work environment.
• 7 years’ experience as a DBA
• 4 years’ experience supporting MSSQL and ORACLE including managing, configuration, and replication of servers
• Proactively monitored servers for potential issues, and provided maintenance recommendations
• Proven ability to work individually and in a team with individual from various backgrounds
• Thorough understanding of diverse database needs, and able to rapidly adjust to change.

SPECILIZATION:

• MSSQL Server, Oracle, MYSQL
• Oracle Database
• AlwaysOn
• MIgration
• SharePoint2016
• Active Directory
• Experience working with Windows server, including Active Directory
• AWS
• Cyber Security
• Backup and Recovery using RMAN
• Backup and Recovery using Pg dump and Pg dumpall
• Database Upgrade and Migration
• Transparent Database Encryption
• Export/Import and Data Pump
• Oracle Enterprise Manager
• Performance Tuning
• Database Security
• Service Now
• DynaTrace
• Sandbox
• Red hat
• Netcoll
• LINUX
• DBMS
• BSM

WORK EXPERIENCE:

Confidential

Responsibilities:

• Participating in daily meetings to discuss about the new database design, modeling and creation.
• Experience with install, configure, and administer database software within the Microsoft SQL server stack including SSRS, SSAS and SSIS
• Migration of data out of MySQL into Azure SQL, AlwaysOn
• Performed MySQL replication setup and administration on Master - Slave and Master-Master.
• Created and deleted users, groups and set up restrictive permissions, configuration of the Sudo files etc.
• SharePoint
• Installing and Configuring PostgreSQL from source or packages on Linux machines.
• Proactively updated the latest security patches to database, which are provided by PostgreSQL open source community
• Delivered innovative BI & Data warehouse solutions.
• Allocated system storage, planned future storage requirements, and maintained system security.

Confidential

Database Administrator

Responsibilities:

• Participating in daily meetings to discuss about the new database design, modeling and creation.
• Experience with install, configure, and administer database software within the Microsoft SQL server stack including SSRS, SSAS and SSIS
• Migration of data out of MySQL into Azure SQL
• Performed MySQL replication setup and administration on Master-Slave and Master-Master.
• Created and deleted users, groups and set up restrictive permissions, configuration of the Sudo files etc.
• Installing and Configuring PostgreSQL from source or packages on Linux machines.
• Proactively updated the latest security patches to database, which are provided by PostgreSQL open source community
• Delivered innovative BI & Data warehouse solutions.
• Allocated system storage, planned future storage requirements, and maintained system security.
• Tuned autovacuum parameters to ensure up to date table stats and reclaim space consumed by dead tuples.

Confidential

Oracle Database Administrator

Responsibilities:

• Installation of MongoDB RPM’s, Tar Files and preparing YAML config files.
• Implement backup, disaster recovery and replication requirements
• Completed basic backup/restore and implemented security functions for various applications using MariaDB (MySQL).
• Performed MySQL replication setup and administration on Master-Slave and Master-Master.
• Designed and developed SQL procedures, query performance tuning.
• Performed CRUD operations on the data imported.
• Performed Tuning test and production database by altering the parameters.
• Managed end-to-end complex data migration, conversion and data modeling.
• 1nstallated, configurated and maintained of MS SQL Server 2005/2008R2/2012.

Confidential

Database Administrator

Responsibilities:

• Implemented simple snapshots to replicate data among production databases.
• Participate in monthly health checks (using tools we developed) and frequently fix production and non-production dashboard issues on OEM.
• Proactively managed standby replication methodologies like Streaming replication and hot standby for disaster recovery.
• Experience in availability SQL Server solutions including Log shipping mirroring replication and clustering
• Managed end-to-end complex data migration, conversion and data modeling.
• Migrated and refreshed data for numerous database environments using the Data Pump Utility (table level, schema level, tablespace level, or entire DB) and RMAN in efforts for TSA Exits within HPE.
• Manage MySQL database and Manage migrations and upgrades