Arun Kumar
210-***-**** ****.********@*****.*** LinkedIn URL www.linkedin.com/in/arun-kumar-gadila DATABASE ADMINISTRATOR
Database administrator (DBA) with extensive 8 years of experience designing, coding, testing and supporting next-generation database solutions in MSSQL Server, MySQL and MongoDB enterprise environments. Effectively plan, install, configure and optimize the IT infrastructure to consistently achieve high availability and performance of servers and data-centre operations across multiple platforms. DBA skills include:
● MSSQL Server Database Administration
● Performance Tuning & Capacity Monitoring
● Data Security, Backup & Recovery
● Standby/Failover Cluster Administration
● Supporting PeopleSoft 9.1
● MongoDB Administration using Ops Manager
● Experience in Google Cloud Platform
● Amazon AWS RDS Instance Administration
● SQL Tuning in MySQL and MSSQL Environment
● Tableau Server Installation and Administration
TECHNICAL EXPERTISE
Primary Skills: MS-SQL, MySQL and MongoDB DBA/Windows Administration Languages: T-SQL/Oracle/C/C++/Power Shall
OS: Windows Server 2016/2012R2/2008R2/2008/2003/2000, UNIX, LINUX Databases: MS-SQL Server 2017/2016/2014/2012/2008R2/2008/2005/2000, MySQL 5.6, 5.7, 8.0, MongoDB 3.2, 3.4, 3.6
DB Utilities: SQL Server Management Utility, Query Analyzer Application Software: Visual Studio 2005/2008, Visual Source Safe, TFS, MS Office Suite Monitoring Tools: AppDynamics, Splunk, Application Manager, Oracle Enterprise Manager(OEM), Ops Manager(MongoDB), BMC patrol, Control-M, HP Open View, Nagios, SQL Profiler, Idera, Red gate, Tivoli, VMware
Backup Tools: Symantec NetBackup, ARCserve, LiteSpeed, Commvault Ticketing Tools Quest STAT CSR, SAP CRM, BMC Remedy, VMware Service Manager, IBM Fault log EXPERIENCE
Client: Avery Dennison,Los Angeles, CA 03/2016 – Till Date Database Administrator
Manage MSSQL, MySQL database administration assignments for diverse industry clients. Enhance database performance, perform restores, implement recovery procedures, handle performance tuning and conduct regular system backups. Ensure technical and functional designs meet business requirements.
● Creating MySQL and MongoDB Instances in Google Cloud Platform, Amazon AWS (RDS & EC2) and administration.
● Worked with AWS technologies like RDS, EC2, S3 Storage, CloudWatch and Lambda.
● Experience with database migrations from on-premise datacenter to AWS and AWS to on-premise servers.
● Worked with GCP technologies like Compute Engines, SQL (1st Gen and 2nd Gen), Google Storage buckets, VPC Networks and Disk management.
● Worked on MongoDB 3.2, 3.4, 3.6 versions. Have hands-on experience in Installing, configuring and upgrading MongoDB in replica-set(Sharding) in GCP environment.
● Creating and migrating MongoDB Databases, Collections and Documents.
● Experience in user administration in MySQL and MongoDB.
● Experience of Database Administration, design, development, maintenance and production support of relational databases, business applications, new server setup, MySql Server installation, upgrade, migration.
● Used Shell scripts on the Linux OS for automating tasks like backing up MySQL, MongoDB database using mysqldump, xtrabackup, mongodump commands.
● Performed Linux/Unix/Ubuntu administrative tasks like configuring cronjobs, mountpoints, disk cleanup activities etc.
● Configured disaster recovery and high availability technologies like Clustering (Always On), Mirroring, Transactional Replication and Log Shipping.
● Managing and monitoring SQL Server 2005/2008/2008R2/2012/2014/2016/2017 four node failover cluster on Windows Server 2008R2/2012/2016.
● Migrating the SQL and DMS scripts from Development-Test-Production using Quest STAT migration tool.
● Performing SQL Server Service Pack Upgrade on Test, Production Servers.
● Experience in planning and implementing Database Security by creating Logins, Users, Roles and assigning permissions according to the requirement.
● Experienced in Database optimization and deploying stored procedures, Triggers, Cursors, Joins, Views, Cursors and SQL on databases: MSSQL, MySQL.
● Upgraded SQL Server databases from SQL Server 2000/2005/2008R2 to SQL Server 2012/2014/2016/2017. Implemented SIDE BY SIDE Migration of databases from SQL Server 2008 to SQL Server 2017.
● Extracting the information requested by Client (Data Extraction, Transformation, and Loading (ETL)).
● Database tuning, Application Tuning & performance monitoring. Fine tuning Initialization parameters, I/O, Memory and Operating System kernel parameters.
● Encrypting the SQL Server databases using TDE (Transparent Database Encryption).
● Database archiving for performance improvement.
● Creating and migrating SSIS packages.
● Modifying the database/table structure, as necessary.
● Familiar with SQL Server licensing and difference between SQL Server Enterprise, Standard and Developer Editions.
● Prepare architecture diagrams explaining data flow and application connectivity to the database. Documenting the technical procedures.
● Install and manage Apache Tomcat, Java, .Net and Adobe Acrobat Reader based on the requirement.
● Installing, configuring, upgrading and downgrading Tableau server with versions 10.2,10.3,10.4,10.5.
● Handled numerous Change Management requests on production servers and Supported 24 X 7 Production on Call.
NTT DATA Bangalore, India
Sr. Technical Executive
06/2012 - 02/2016
Key projects:
Project 1: McKesson
SQL DBA
● Monitoring and managing over 1000 SQL servers in which 357 are production and 247 are development servers.
● Acting as a single point of contact for the project by maintaining the minimum downtime.
● Installing and configuring BMC PATROL tool on all the Windows servers for monitoring SQL databases.
● Using SECURE LINK application to login to the server for troubleshooting to ensure the maximum secure environment.
● Monitoring Event Viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.
● Hands-on experience in resolving locks deadlocks, handling Isolation levels and performance issues like CPU, I/O, Memory bottlenecks.
● Experience in planning and implementing Database Security by creating Logins, Users, Roles and assigning permissions according to the requirement.
● Exquisite skills in SSMS-Creating and scheduling jobs, alerts and operators with SQL Server Agent, handling Backup/Recovery of databases, Replication, Linked Servers, and Database Maintenance.
● Expertise in Performance Tuning, Index Tuning, Maintenance, Troubleshooting, Query Optimization, Client/Server connectivity and Database Consistency Checks using DBCC Utilities, DMVs and DMFs.
● Experience in installation of MS SQL Server 2005, 2008, 2008R2 and 2012.
● Used PowerShell script for SQL Server Maintenance activities.
● Analyzing and troubleshooting issues like log spaces, blocking and disk spaces.
● Performing Index rebuild, re-organize and System reboot activities.
● Experience in analyzing fragmentation of indexes and troubleshooting.
● Involved in migration of DTS Packages (2008) to SSIS (2012/2014) and troubleshoot migration issues.
● Experience in Preparing the Daily, Weekly and monthly status report. Project 2: Philips LifeLine
Windows Administration
● Monitor, Resolve alerts received for Enterprise Network, Windows Servers using tools like HP Open view (Reflection 9.0),Control M/Enterprise Manager 6.4.0.
● Monitor over 1500 devices using HP Open view & Control M for Network problems.
● Monitor, Create and Resolve tickets using VMware Service Manager Tool.
● Working on Active directory (windows server 2003 & 2008). Like creating AD accounts and Email Accounts, Distribution list, providing the Folder access, Adding and Removing users to the AD groups.
● Creating AD groups, Share point groups & performing Exchange Task.
● Working as Application administration for 20 Applications like Creating SAP, PeopleSoft, CPC and Actuate, Postini Accounts and Philips Email ID creation etc.
● Disabling and deleting the accounts and adding delegates to an Email Account.
● Resetting passwords & troubleshooting.
Project 4: Unisys CMC Operations
Mainframe Admin
● Working on Unisys A-series VSE500 Mainframe and UNIX servers, supporting the British Telecom voice mail and text services.
● Single Point of Contact for the project.
● Maintaining a service level of 100% with NO downtime involvement.
● Document Manager: Managing/updating a set of 500+ documents involved in the project on a need basis.
● Checking the physical aspects of the Unisys Mainframe servers remotely via ISO SCAN and taking necessary actions if an anomaly is recorded.
● Handling mails and answering BT queries through the phone.
● Escalating to Support in case of issues, raising fault logs for incidents and planned works Project 4: LSI (Large Scale Infrastructure)
Windows/VMware Administrator
● Managing all the servers with the help of NAGIOS
● Validating Backup policy with the help of BacodaPrism.
● Backing up the configuration of network devices through Kiwicat configuration tool.
● Create, update and close trouble tickets by using Remedy tool.
● Responsible for Windows servers monitoring and maintenance
● Creating User mailbox, conference/room mailbox
● Troubleshooting mailbox issues, migrations
● Monitoring and troubleshooting mail queue length issues
● Performing regular backup checks
● Vendor coordination on Physical servers Hardware issues
● Point of contact for all Windows/VMware/Network problems and maintenance.
● Responsible for creation of user login accounts and monitoring daily activities in Active Directory, AD backup, Security groups and DL’s.
● Installing applications, windows patches, upgrading and maintenance of operating systems.
● Manage alerts pertaining to the Circuit/Managed Router and troubleshoot, log into the managed device to check the circuit statistics and other parameters.
● Analyzing & Troubleshooting the routing,Interface and physical device issue on Cisco Routers, Palalto Firewall, Juniper Firewall and Nexus switches
● Managing the DNS and DHCP using INFOBLOX.
● Expertise in WhatsUp Gold, MRTG, Net Disco and Net flow Analyzer. Project 5: Royal Greenland
Windows/Network Administrator
● Monitoring and basic troubleshooting using Solar winds 8.0, OP Manager 9.0 tools.
● Level 2 support for AD and Exchange related issues.
● Backups monitoring, scheduling and troubleshooting using Symantec Backup Exec and ARCserve Server tools.
● Ticketing – Issues handling and stats reporting
● Maintaining the response and resolution SLA for incidents.
● Develop and maintain related documents and SOP.
● Maintain server and network devices inventory and renewal of contracts
● Configure, Schedule & Administer backups
● Windows Patch Management
REWARDS & RECOGNITION
Spot award winner at NTT DATA for the year 2013-2014 Outstanding award winner at NTT DATA for the year 2014-2015 EDUCATION & TRAINING
Sikkim Manipal Institute of Technology Bangalore, India -MBA-IT (Correspondence) Loyola Academy Degree & PG College Hyderabad, India-BA (Economics, Math’s & Computer Applications) ITIL V3 training
SQL Server Database Administration training