Sql Server Team Lead
Resume:
Arun Macherla
Executive Summary
**+ years' IT experience as Oracle 8i-11g/12c,18c,19c,(Testing in the lab 23ai) Data Guard Technologies as Production, Stage (UAT), Development Oracle Database Architect /Administration/Database Consultant, Oracle Golden Gate. Working as DBA team lead and good team player. Designed and implemented DEV/QAT/Production databases.
Work experience with FED client Social Security Administration.
15+ years' experience in SQL Server 2005/2008/2012/2014/2016/2019 Database Administration-Log Shipping, Always ON. Exposure to DB2/MySQL, PostgreSQL, Hadoop, and Casandra.
Proven experience in analysis, architect, design, development, maintenance, production support and database administration of mission critical systems based on Client/Server, Intranet Cloud, and Internet Technologies.
Experience with IBM Cloud, AWS, Microsoft Azure, Oracle Cloud.
Interaction with Customers to get the service level needs and getting signoff on SLAs.
Excellent hands on designing the backup and recovery strategies for the production databases.
Experience with ITIL/Agile processes for Incident/Problem/Change/Release/configuration Management and capacity planning.
Monitoring Tool visualizer, Netcool, BMC Patrol, Nagios, OEM 13. Project Tracking Management JIRA.
Oracle: having expertise in performance tuning of databases AWR, ASH, ADDM and SQL Query tuning, Large Oracle OLTP Database System, Designing, Administration, Monitoring, OEM Grid Control, database installation, migrations, upgrade, patching, database design, cloning, RAC, ASM, DR using data guard and standby databases, golden gate, backup and recovery, TOAD, OEM Installation, OEM Upgrade and patching.
SQLSever: Installation, configuration, administration, and maintenance of SQL Server instances/database on production and development environments, backup and restoration, DB restore procedure, setup High-Availability (failover clustering, database mirroring, log shipping and replication, always on). Upgrade from SQL server 2008-2016. Designing and implementation SQL Server clustering, log shipping, backup, and recovery strategy.
Experience in project transition for moving projects, managing multiple parallel projects at once and working towards the same goal and result that includes project management and program management.
Experience as a leader and contributor at many projects in multi-national companies working with Global Diverse teams, planning, team building, mentoring. On lots of positions worked alone. Experienced on working efficiently on multiple projects and teams in high pressure environments. I am confident in creating and delivering Project Presentations. Discussion with the client and find out the expectation from project perspective.
ACHIEVEMENTS: Successfully maintained more than 9000+ PROD databases 98% uptime, undertaken major migration/upgrade/patching projects, Lead major Nagios monitoring project.
EDUCATION: Bachelor of Commerce from Osmania University
Masters of Computer Applications
CERTIFICATIONS :
Oracle Database Administrator Certified Professional (OCP)
ACSE (Advance Certificate in Software Engineering) from IBM.
HWC (Honours Diploma in Web-Centric Computing) from NIIT.
Training
Oracle RAC from oracle university Bangalore, India
Oracle 10g/11g DBA, New Features of Oracle, Wilshire Technologies, Hyderabad, India.
Oracle 8i DBA, New Features of Oracle 9i, Wilshire Technology, Hyderabad, India
Unix Shell scripting Wilshire Technologies, India.
Unix/HP/Linux/Solaris 8/9 Administration, Wilshire Technologies, Hyderabad, India.
Company: Integrated Tech Solutions LLC (ITS) July 2024 till date
Client: Elevance health
Oracle Database Architect
Environment: 12C/19C SQL server 2016/2019/2022, Hadoop 3.3 Windows, Linux
Change Management (CR)/trouble ticket management (CASE)
Administering various Oracle and SQL Server databases/Database Security
Managing the Oracle OID and Jira, Confluence, Tidal jobs, CyberArk
Handling day-to-day production support
Creating and maintaining tablespaces
Worked extensively on multi-tenant architecture [CDB/PDB] backup-restore
Estimating and properly sizing data, index, and rollback segments.
Creating users, Roles, Profiles
Migrated/upgraded databases from 12c-19c
Managing Standby databases by using DATAGAURD utility
Setup and configure Log shipping on production databases.
Creating Snapshots NetApp and views
Auditing User Activities with custom scripts.
Control user access to resources and information
Backup & recovery strategies with and without RMAN
Validating Database Backups
Experience in Ansible, automation and scripting
Identify and resolve ORA errors and database application issues
Importing and exporting (datapump) data between databases and tablespaces
Worked on scripts for loading data using SQL*Loader
Creating Unix/win job schedules
Design Databases using normalization rules
Tuning the database by using STATSPACK, UTLESTAT UTLBSTAT, TKPROF, AWR and other Utilities
Expert level skills in TSQL, Stored Procedures, and Triggers
applying patches, cloning database
Database refreshes, IBM Tivoli Storage Manager backups, TSM Tivoli Data Protection (TDP) ASPERA COPY.
Raising TAR / SR and contacting Oracle/Microsoft for critical/vendor issues. Discuss the resolution impact
Supported WEBLogic env, Oracle E-Business Suite Applications
Worked with Workday, BOX, SLACK, GITHUB, SERVICE NOW, Teams, FACETS, TIDAL, Confluence, Jira, GitHub.
Environment: Linux/Windows, Oracle 19c Toad, MS OFFICE, Citric, Solaris, PL/SQL Developer, Netcool, SAP, Service Now SIEBEL, DevOps, Peoplesoft HR, Peoplesoft FIN, Oracle RAC Oracle Dataguard,
Company: IBM Corp/Kyndryl Corp
Client: Bank of America/VISA USA/ACS Help Inc/Target/ April 2016 to July 2024
Walgreens/American Airlines/ [many more]
Fed Client : Social Security Administration
Infrastructure Specialist DBA.
Environment: Oracle 9i /10g/11g,12C SQL server 2005/2008,2014/2016, DB2/MySQL,
Hadoop Windows, Linux, HP, and Solaris
Change Management (CR)/trouble ticket management (CASE)
Administering various Oracle and SQL Server databases/Database Security
Managing the Oracle databases in Financial, HR Peoplesoft and SAP systems env
Handling day-to-day production support
Creating and maintaining tablespaces
Estimating and properly sizing data, index, and rollback segments.
Creating users, Roles, Profiles
Migrated/upgraded databases from 8i,9i to 10g,11g,12c Knowledge of 18c,19c
Managing Standby databases by using DATAGAURD utility
Setup and configure Log shipping on production databases.
Creating Snapshots and views
Auditing User Activities
Control user access to resources and information
Creating and managing data files, multi-tenant container database (CDB).
Backup & recovery strategies with and without RMAN
Validating Database Backups
Experience in Ansible, automation and scripting
Identify and resolve ORA errors and database application issues
Importing and exporting (datapump) data between databases and tablespaces
Worked on scripts for loading data using SQL*Loader
Creating Unix/win job schedules
Design Databases using normalization rules
Tuning the database by using STATSPACK, UTLESTAT UTLBSTAT, TKPROF, AWR and other Utilities
Fine-Grained Auditing for Real-World Problems
RAC, ASM, OCFS.
Creating, Refreshing Materialized Views
Expert level skills in TSQL, Stored Procedures, and Triggers
applying patches, cloning database
Database refreshes, IBM Tivoli Storage Manager backups, TSM Tivoli Data Protection (TDP) ASPERA COPY.
Raising TAR / SR and contacting Oracle/Microsoft for critical/vendor issues. Discuss the resolution impact
Supported WEBLogic env, Oracle E-Business Suite Applications
Worked with Workday, BOX, SLACK, GITHUB, SERVICE NOW
Environment: HP/Linux/Solaris/Windows XP Professionals, Oracle 8i/9i,10g,11g,12c/18c Toad, MS OFFICE, Citric, Solaris, PL/SQL Developer, Netcool, SAP, Service Now SIEBEL, DevOps, Peoplesoft HR, Peoplesoft FIN, Oracle RAC Oracle Dataguard, Golden Gate, Sqlserver 2000/2005,2008,2012,2014/2016/2019
Company: AT&T
Client: Bank of America/VISA USA/ACS Help Inc/Target [many more] Dec 2008 to April 2016
Fed Client : Social Security Administration
Professional-Database Administrator
Environment: Oracle 9i /10g/11g,12C SQL server 2005/2008, DB2/MySQL, Hadoop Windows, Linux and Solaris
Change Management (CR) /trouble ticket management (CASE)
Administering various Oracle and SQL Server databases
Managing the Oracle databases in Financial, HR Peoplesoft and SAP systems env
Handling day-to-day production support
Creating and maintaining tablespaces
Estimating and properly sizing data, index, and rollback segments.
Creating users, Roles, Profiles
Migrated/upgraded databases from 8i,9i to 10g,11g,12C
Managing Standby databases by using DATAGAURD utility
Setup and configure Log shipping on production databases.
Creating Snapshots and views
Auditing User Activities
Control user access to resources and information
Creating and managing data files
Backup & recovery strategies with and without RMAN
Validating Database Backups
Identify and resolve ORA errors and database application issues
Importing and exporting (datapump) data between databases and tablespaces
Worked on scripts for loading data using SQL*Loader
Creating Unix/win job schedules
Design Databases using normalization rules
Tuning the database by using STATSPACK, UTLESTAT UTLBSTAT, TKPROF and other Utilities
Fine-Grained Auditing for Real-World Problems
RAC, ASM, OCFS
Creating, Refreshing Materialized Views
Expert level skills in TSQL, Stored Procedures, and Triggers
applying patches, cloning database
Database refreshes
Raising TAR / SR and contacting Oracle/Microsoft for SEV 1 issues. Discuss the resolution impact
Environment: HP/Linux/Solaris/Windows XP Professionals, Oracle 8.1.7/9i,10g,11g,12c Toad, MS OFFICE, Citric, Solaris, PL/SQL Developer, Netcool, SIEBEL, Peoplesoft HR, Peoplesoft FIN, Oracle RAC Oracle Dataguard, Golden Gate, Sqlserver 2000/2005,2008,2012,2014
Company: Allied Solution Group Inc
Client: GE Healthcare Apr 2008 to Dec 2008
Sr Database Administrator
Change Management (CR) /trouble ticket management (CASE)
Administering various Oracle and SQL Server databases
Environment: Oracle 9i /10g, SQL server 2005, Windows, Linux, and Solaris
Handling day-to-day production support
Creating and maintaining tablespaces
Estimating and properly sizing data, index, and rollback segments.
Creating users, Roles, Profiles
Migrated databases from 8i,9i to 10g
Managing Standby databases by using DATAGAURD utility
Creating Snapshots and views
Auditing User Activities, HAPPA Compliant
Control user access to resources and information
Creating and managing data files
Backup & recovery strategies with and without RMAN
Validating Database Backups
Identify and resolve ORA errors and database application issues
Importing and exporting (datapump) data between databases and tablespaces
Worked on scripts for loading data using SQL*Loader
Creating Unix/win job schedules
Design Databases using normalization rules
Tuning the database by using STATSPACK, UTLESTAT UTLBSTAT, TKPROF and other Utilities
Fine-Grained Auditing for Real-World Problems
RAC, ASM, OCFS
Creating, refreshing Materialized Views
Expert level skills in TSQL, Stored Procedures, and Triggers
applying patches, cloning database
Database refreshes
Raising TAR / SR and contacting Oracle/Microsoft for SEV 1 issues. Discuss the resolution impact
Environment: HP/Linux/Solaris/Windows XP Professionals, Oracle 8.1.7/9i,10g,11g Toad, MS OFFICE, Citric, Solaris, PL/SQL Developer, Netcool, SIEBEL, Peoplesoft HR, Peoplesoft FIN, Oracle RAC Oracle Dataguard, Sqlserver 2000/2005
Company: USi an AT&T Company
Client: Bank of America/VISA USA/ACS Help Inc May 2005 to Mar 2008
Sr Database Administrator
Company: INTELLIGROUP Client: US Internetworking.
Sr Database Administrator Mar 2004 to May 2005
Company: Raasi Enterprise solutions ltd
Client: Regional Transport Authority Aug 2001 to Mar 2004
Government of Andhra Pradesh, India
Database Administrator
Environment: Oracle 8i /9i, Windows, Linux
COMPUTER HARDWARE AND SOFTWARE SKILLS:
Hardware
:
E450, Sun Ultra Sparc, RM600, Intel x86
Operating System
:
HP-UX 10.x/11.x, Sun Solaris 7/8, AIX, Windows NT 4.0, Windows XX,
Windows XP Professionals, Linux RHEL
Databases
:
Oracle19c/18c/12c/11g/10g/9i/8i/8/
Sqlserver 2005/2008/2012/2014/2016/2019
PostgreSQL/Hadoop/DB2/MySQL
Package/Other Software
:
Oracle Enterprise Manager, TOAD
Tools/Utilities
:
RMAN, TOAD, MS Office, top, sar Statspack, PLAN, TKPROF and
AWR, ADDM
Web Technologies
:
HTML, CGI Perl, CGI Using C++
Languages
:
Programming through C, OOPS with C++, IDE VisualAge for Java
Storage/Cloud
:
Veritas NetBackup, 3Par, EMC, NetApp, IBM Tivoli, Storage Manager backups,
TSM Tivoli Data Protection (TDP) IBM ASPERA COPY. AWS, Azure, IBM Cloud, OCI
Contact this candidate