We provide IT Staff Augmentation Services!

Senior Dba And Technical Lead Resume

SUMMARY:

  • Senior Database Administrator and Architect with Tata Consultancy Services Ltd for more than 11.5 years and current role is Infrastructure Lead for a major utility customer in North America. Performed the role of Technical Lead as L2 and L3 MSSQL Server and Oracle DBA. Experienced DBA in both on premise and cloud platforms. Achieved client handling experience in onsite positions in different countries including Australia, Canada and United States. Managed service delivery and operations for different infrastructure towers. Successfully handled major upgrade and data center migration projects. Implemented HA - DR database solutions for many customers. Extensive experience in client handling, client meetings and reporting. Successfully managed transition of many new customers.
  • 11.5 + Years of experience as SQL Server DBA and Oracle DBA.
  • Infrastructure Lead and Midrange Lead.
  • Worked as MS SQL SERVER Database Administrator on versions MSSQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
  • Managed SQL Server instanced in HA clustered environment. Having experience in mirroring and log shipping.
  • Designed and configured MSSQL AlwaysOn technology with listener and groups.
  • Managed complex SQL Server environments with 24*7 production support. Performed different kind of database maintenance and having extensive experience in change and release management activities.
  • Worked on various Oracle versions like 8i, 9i, 10g, 11g and 12c.
  • Worked in Oracle Exadata RAC with data guard.
  • Worked in AWS cloud platform and has database migration experience to AWS cloud environment.
  • Worked as a technical specialist in migrating business critical production databases from lower Oracle/MSSQL Server versions to higher Oracle/MSSQL Server versions.
  • Worked as a Technical Lead in database migration from Oracle to SQL Server.
  • Experience in advanced performance tuning and complex database activities like cloning, business copy refreshes, managing standby and data guard etc. critical applications like Siebel, JDE, SAP, Enterprise Data Warehouse, IVR, NICE, Cognos, Informatica, MAXIMO, HPQC ALM, SHAREPOINT, Citrix, Reddot, Verint, KANA, customer facing java and web based applications etc.
  • Qualitative experience of full life cycle of Pre/Post Go-Live Support and team management functions.
  • An effective communicator with exceptional relationship management skills with the ability to relate to people at any level of business and management.

TECHNICAL SKILLS:

Software Products: SQL SERVER 2005, 2008, 2008 R2, 2012, 2014, 2016, Oracle 8i, 9i, 10g, 11g, 12c, Amazon Web Service (AWS), Microsoft Azure, UNIX HP-UX, Solaris, Linux, AIX, Windows Server 2000, 2003, 2008, 2012, PL/SQL, Shell Scripting, HPQC ALM.

Tools: SQLSentry, SSMS, Oracle GRID, Oracle Enterprise Manager, Toad, BMC Remedy, HP Service Manager, PL/SQL developer, SolarWinds, ServiceNow

Methods: ITIL, Agile, Scrum

PROFESSIONAL EXPERIENCE:

Confidential

Senior DBA and Technical Lead

Responsibilities:

  • DBA lead and onsite coordinator.
  • Configure and manage MSSQL HA cluster environments, Mirroring and AlwaysOn instances.
  • Support large scale SQL Server environment on MSSQL 2008, 2008R2, 2012, 2014 and 2016 versions.
  • Manage database migration to Amazon Web Service (AWS) cloud.
  • Installation and configuration of MSSQL Server and Oracle instances on latest platforms.
  • Manage SQL Server backup and recovery using EMC Networker
  • Database design.
  • Manage Oracle Exadata on RAC.
  • Performance tuning and capacity planning
  • Performing maintenance activity for Oracle databases with versions Oracle 11g and 12c
  • Support physical standby databases and data guard.
  • Manage OEM 12c cloud control for monitoring
  • Midrange lead for Database, Storage, VMware, Server, UNIX and Backup Towers.
  • Manage service delivery and operations
  • Handle vulnerability remediation activities.
  • Client reporting, handling business meetings and discussions

Confidential

Senior DBA and Technical Lead

Responsibilities:

  • Manage very large and complex MSSQL Server environment with 2800 databases spanning across 120 SQL Server instances.
  • Installation and configuration of MSSQL Server instances.
  • Performing maintenance activity for MS SQL SERVER databases with versions MSSQL 2005, 2008, 2008 R2, 2012 and 2014.
  • Manage databases in Microsoft Azure cloud environment
  • Database design.
  • Configure MSSQL HA cluster environments and AlwaysOn instances
  • Installation of patches as when required.
  • Troubleshooting job failures and database incidents.
  • Manage SQL Server database compression activities.
  • Capacity planning.
  • Manage database backup, restoration and log shipping
  • Manage database mirroring, replication and log shipping features
  • Implement change requests as and when required. performing maintenance activity for Oracle databases with versions Oracle 10g, 11g and 12c.
  • Backup and recovery activities with the help of Oracle Recovery Manager (RMAN) and OS commands.
  • Database cloning as and when required.

Confidential

Senior DBA

Responsibilities:

  • Installation and maintenance of ORACLE and MSSQL Server instances.
  • Performing maintenance activity for Oracle databases with versions Oracle 10g, 11g and 12c.
  • Performing maintenance activity for MS SQL SERVER databases with versions MSSQL 2005, 2008, 2008 R2, 2012 and 2014.
  • Database design
  • Configure MSSQL HA cluster environments and AlwaysOn instances
  • Installation of patches as when required
  • Creating databases manually as well as by using Oracle Database
  • Configuration Assistant and SQL Server Management Studio (SSMS)
  • Backup and recovery activities with the help of Oracle Recovery Manager (RMAN) and OS commands. Monitoring & Troubleshooting Backup Errors.
  • Database cloning as and when required.
  • Upgrading oracle an MSSQL version of databases.
  • Performance tuning.
  • Manage standby and DR databases.
  • User management.
  • Data archiving.
  • Change management for performing any kind of database change request.
  • Handling client meetings, CAB and reporting
  • Data warehouse job management.
  • Cognos BI reporting and administration.
  • Cognos Planning administration and management.
  • HPQC ALM administration.

Confidential

Database Administrator

Responsibilities:

  • Implementing Oracle grid computing
  • Database design and capacity planning
  • Manage MSSQL Server databases
  • Business Copy Refreshes
  • Installation of Oracle server and client software and patch as when required
  • Creating databases manually as well as by using Oracle Database Configuration Assistant.
  • Backup and recovery activities with the help of Oracle Recovery Manager (RMAN) and OS commands. Monitoring & Troubleshooting Backup Errors.
  • Restoring and recovering databases from backups
  • Upgrading oracle version of database
  • Data handling - executing database change requests as and when required, running export and import.
  • Analyzing database schemas, tables and indexes for improving database performance.
  • Monitoring - Monitoring daily hot backups of critical production databases
  • Monitoring database performance through OEM and Oracle Performance Manager tool
  • Running Statspack reports and analyzing them
  • Building standby databases from hot as well as cold backups.
  • Preparing Shell scripts and automating them through CRON and scheduler for scheduled database monitoring tasks.
  • User creation and granting roles, privileges.
  • Identifying poor performing user queries and tuning.

Hire Now