SUMMARY

• Over 10 years of experience as a Data Base Administrator with expertise in M/S Sql Server, PostgreSQL, Oracle and other databases.
• Expertise in the PostgreSQL, Oracle, and MS SQL Server databases administration activities.
• Has been a Database Administration Lead in several projects.
• Expertise in database administration, patch, upgradation, planning, design, build/delivery, deployment, monitoring, standards, compliance, and audit.
• Enhance database performance, perform restore, implement recovery procedures, and conduct regular system backups.
• Experience in migrating on - site solutions to cloud-based offerings, such as Amazon's AWS, Rackspace, Orange and Azure.
• Take part in technical and business discussion, share ideas and provide feedback in continuing the improvement of the database team.
• Strong experience in Backup solution for various servers, applications, and databases.
• Experience in data migration, upgrades with data quality, integrity, and completeness.
• Excellent exposure and experience in Virtual & Hyper view environment.
• Expertise in Windows scripting, Linux Scripting, Linux Scripting which includes Bash shell, Borne Shell and Korne Shell.
• Owns and handle escalations related to database issues, incidents and problems.
• Established service level agreements with business users.
• Excellent communication skills, team player, self-learner.
• Ability to develop proficiency and adapt to new technologies and methods in a short period of time.

TECHNICAL SKILLS

Databases: PostgreSQL 9.5, MSSQL Server 2005, 2008,2012 & 2016, DB2, Oracle 10g & 11g &12C, Oracle RAC, ASM, data guard, Oracle Golden Gate, RMAN Backup, My SQL Server (Maria DB), PostgreSQL, NoSQL databases like DynamoDB, MongoDB and ADBASE, SAP HANA Basis administration, Oracle Exadata, IMS DB

Cloud: AWS, Azure cloud, RedShift

Languages: COBOL, Natural, JCL, SQL, T-SQL, C, C++, Python, PL/SQL and Java/J2EE

File Systems & Scripting: VSAM, PowerShell, Windows and Linux scripting

Operating Systems: OS/390, ESXi 5.1, MVS/ESA, Windows XP/, UNIX, RHEL 5.9, AIX

Backup Solution: HP data Protector 8.1, CA Arc, Veeam Backup & Replication 8.0.

Tools: Oracle OEM, SSMA, SSIS, ODBC, TSO/ISPF, SPUFI, QMF, Endeavor, File-Aid and DCLGEN, T-SQL and ETL

Virtualization: Hyper-V & ESXI

Online Tool: CICS, IMS DC

GUI: VB 5.0

ERP: SAP HR, SAP BW

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

Senior Database Administrator

Responsibilities:

• Handle the & EDB PostgreSQL 9.5, 10 and version 12 (EFM) databases, MS SQL server (Always-On) and Oracle 12c and 19c (OEM, RAC, data guard & ASM, RAMAN backup).
• Budgeting and capacity planning, as well as systems performance and uptime management.
• Drive continuous improvement through optimizations of systems and processes for existing and new applications.
• Manage multiple applications or service areas and projects simultaneously to ensure on-time response, quality delivery and resolutions.
• Act as the department point of contact with cross-functional teams, including product development, engineering, quality assurance and technical support.
• Manage 24/7/365 operations in a business-critical environment.
• Manage day-to-day database operations and DBA charters for production databases and projects.
• This includes database administration, patch, upgradation, planning, design, build/delivery, deployment, monitoring, standards, compliance and audit.

Confidential

Database Administrator

Responsibilities:

• Database administrator for MS SQL database.
• Establish and builds strong working relations and partnerships with Business Units and Senior Management.
• Provide database assistance and problem support to application developers, business analysts and business users.
• Provides technical assistance and mentoring for staff for developing conceptual, logical database design and the physical database.
• Serve as support for database administration tasks including configuration management, backup/recovery, performance optimization, space management and incident management.
• Interface with developers, network, virtualization, storage and systems operations teams to resolve problems with applications and database systems.
• Setup the new clustering for MS SQL Server 2017 (Active/Passive & Always On).
• Perform database deployments and provide support for application releases.
• Conduct Security vulnerability assessment, review and recommend security infrastructure as well as databases.
• Help developers to improve the performance of that query by tweaking it or modifying indexes.
• Design, develop, test, deploy and maintain database security and audit solutions.
• Administer and monitor 24/7 applications and systems, developing automated alerts to warn about a failure.
• Provide support in capacity planning, forecasting, and tuning.
• Develop and test storage strategies and disaster-recovery plan for company's operational databases.
• Databases upgrade from MS SQL Server 2014 to MS SQL Server 2019.
• Databases migrating from Rackspace, Orange to AWS cloud.

Confidential

Senior Database Administrator

Responsibilities:

• Handle the PostgreSQL (EFM) databases, Oracle (OEM, RAC, data guard & ASM, RAMAN backup), MS SQL (Always on, Replication) and MYSQL administration supports.
• Monitoring data growth, table space fragmentation and correcting the problem.
• Implementing Capacity Planning and sizing the table space accordingly.
• Optimization of SQL queries or stored procedures to improve application effectiveness and performance.
• Enhance database performance, perform restore, implement recovery procedures and conduct regular system backups.
• Apply appropriate Database patches.
• Work with storage administrators and backup administrators for access and reporting.
• Conduct Security vulnerability assessment, review and recommend security infrastructure as well databases.
• Meeting regularly with senior managers, stakeholders, project teams and team leaders to review status, make recommendations, and resolve problems. Working with both on site and offshore solution providers.
• Provide technical guidance and provide support to headquarters and regional offices regarding implementation of corporate wide application systems and IT infrastructure issues and best practices.
• The Below projects are handled in DBS
• Handle the databases migrating from On-premise to cloud.
• Deploy the PostgreSQL environment using Puppet and Ansible.
• Use Python & PHP to develop the monitoring dash board.

Confidential

Sr. Executive (Senior Database Administrator)

Responsibilities:

• Manage Oracle (OEM, RAC, data guard & ASM, RAMAN backup), MS SQL server (Cluster, Replication, Always On), NoSQL databases, PostgreSQL and MYSQL database administration.Enhance database performance, perform restores, implement recovery procedures, handle performance tuning and conduct regular system backups. Ensure technical and functional designs meet business requirements.
• Optimization of SQL queries or stored procedures to improve application effectiveness and performance.
• Build and migrated the database servers on Azure cloud.
• Designed and planned a zero downtime upgrades of databases.
• Monitoring data growth, row migration, table space fragmentation and resolving the problem. Implementing Capacity Planning and sizing the table space accordingly.
• Developed and tested storage strategies and disaster-recovery plan for company's operational databases & applications, delivering solution that guaranteed recovery performance and high availability.
• Played as System administrator for RHEL (6.0) & Windows servers (2000, 2008, and 2012) and Operational support for DC (Domain controller) and AD (Active Directory). Participated in Disaster recovery.
• Involved in IT auditing & handle the incident management. Coordinate with vendors to implement the new projects, prepared the invoices for new projects, created the project estimations and allocate the budgets.
• Migrated the data from Oracle database (10g & 11g) to MSSQL (2012 & 2014) used SSMA.
• Setup the new clustering databases in the both environments (Oracle (11g, 12c) and MS SQL Server 2014 (Active/Passive & Always On).
• Build the standalone 2008 R2 database environment for our new financial system called as Sun System.
• Participate in the oracle database version up gradation project from 10g to 11g.
• Initiated and upgraded from MSSQL 2005 to MSSQL 2012 R2 for our online system called as I channel.
• Implemented the Veeam Backup solutions for VM & MSSQL DB servers & HP Data protector for Oracle Databases.
• Converted from physical to virtualization around 30 servers used Veeam converter.
• Created new MY SQL 5.X environment for our mobile application system.
• Configured the Pentaho data integration tool (ETL) for data replication for Sompo regional data warehouse system.
• Build the New DR site in the Singapore for our APAC regional countries. Data Centre upgrading.
• Worked on the oracle Golden Gate (OGG) project which going to be replicated the real-time data from production to operation environment (One Way).