Ashwini Thippenahalli Chandrappa

SQL SERVER DATABASE ADMINISTRATOR

Email: ac4hoz@r.postjobfree.com

Phone number: 858-***-****

Authorized to work in the US for any employer

SUMMARY:

Around 6+ years of experience in Information technology having excellent experience in MS-SQL [2008R2, 2012, 2014,2016] servers and Oracle database administration. Involved in database design, Capacity Planning, development and testing on production and non-prod environments.

Extensively worked on installation, configuration, migration, upgradation, monitoring, space management, database backup, recovery procedures and troubleshooting.

Migrated databases and upgraded the versions from SQL 2008R2 to 2012SP2 and 2012 to 2016 SP1.

Implemented high availability & disaster recovery techniques with ALWAYS ON Failover clustering, Database Mirroring, Transactional Replication and Log Shipping.

Experience in implementing SQL Server security by creating users, roles, configuring permissions, database authentication modes and assigning roles to users.

Implemented database and backup security with encryption and always encrypted features.

Involved in performance monitoring and tuning using SQL Profiler, DBCC commands, DMVs and Windows viewer and Performance monitor.

Excellent experience in creating database and database Objects like Tables, Stored Procedures, Views, Triggers, User defined data types and functions.

Experience in creating scheduled tasks for regular database backup and maintenance activities.

Good working experience on SSRS.

Extensively used native and third-party tools like SQL profiler, Tuning advisor, Performance Monitor, Resource monitor and Litespeed.

Excellent in writing SQL, T-SQL queries and stored procedures as per the business requirements.

Experience in stored procedures code review and documenting best practices.

Good knowledge on implementing ALWAYS ON AVAILABILITY GROUPS

Good Knowledge on SQL Server licensing model.

Extensively worked on Linux and windows Operating systems.

Familiar with all phase of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development, Testing and Implementation

Incident Management and Change Management Requests on Production, UAT and QA Servers were Handled and Resolved Using Service now application. .

Ability to work on multiple tasks in a fast-paced environment independently and in a team.

Excellent experience on Oracle core database administration.

Good hands on experience in implementing high availability and disaster recovery solutions using RAC (Real Application Cluster) and Data guard.

Successfully implemented 3 nodes cluster with ASM on Oracle 11g.

Implemented Physical and snapshot standby databases using DataGaurd.

Expertise in collecting and diagnosing the TKPROF, AWR and ADDM reports for performance tuning.

Experience in migrating databases from 11g to 12c.

Experience in migration of databases from non-RAC to RAC and non-ASM to ASM.

Excellent experience on backup and restore process using RMAN and data pump utilities.

Extensively used Oracle Enterprise Manager 12c for administration.

WORK EXPERIENCE

SQL Server DBA

Tillster, CA- Oct/2017 to present

Tillster provides end to end technology and business solutions to empower restaurants and consumers globally by simplifying digital ordering, improves customer engagement and grows sales to its customer. We are the DBA team of 4 members responsible to manage 300 databases across prod and non-prod servers.

Responsibilities:

Installing, configuring, managing, monitoring and troubleshooting SQL Server 2014/2012/2008R2 versions in a clustered and standalone environment.

Migrated SQL Server 2008 to 2012. Also, created detailed documentation of steps taken during the migration process.

Provided High Availability and Disaster Recovery Solutions using Backup and Restore, Replication and Always On.

Upgrading the existing servers with Service Packs, Patches and Hot fixes.

Configured extended events for SQL tracing.

Tuned long running queries by utilizing DMVs and Query Tuning Adviser wizard.

Involved in change writing, Peer review and code deployment to production and staging environment.

Involved in restore operations to refresh the data from production to test servers.

Monitored database status including CPU, memory, I/O, space, blocks using SQL Server Utilities.

Regular monitoring of SQL Server Agent jobs, checking event logs and error logs of any issues.

Involved in troubleshooting clustered and standalone environment issues.

Implemented the TDE in all the Production servers.

Experience in using SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.

Optimized the performance of queries with modification in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes wherever necessary.

Reorg and rebuilding the indexes at regular intervals for better performance.

Incident Management and Change Management Requests on Production, UAT and QA Servers were Handled and Resolved Using Service now application.

Environment:

Microsoft SQL server 2016/2012/2008R2, SQL profiler, Tuning advisor, SSMS, Windows Enterprise Server 2008R2 and 2012 cluster, ServiceNow, T-SQL, SSRS, Linux 6.8, MySQL, service now Incident management tool, Power shell

SQL Server Database administrator

Cast and Crew entertainment, CA-Feb/2017 to Sep/2017

CAST AND CREW is premier provider of technology-enabled payroll and production-management services to the entertainment industry. We are responsible to manage and support around 300 MSSQL databases and 100 Oracle databases across prod and non-prod environments.

Responsibilities:

Installed and Configured SQL Server 2012 on clustered environment and standalone machines.

Performed backup using backup compression and encryption in MS-SQL Server 2008R2 on clustered environment.

Implemented high availability on the various servers using Replication, Log-Shipping and Mirroring.

Implemented and tested the point in time recovery of the production databases.

Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes whenever necessary.

Configured data partitioning and table partitioning on huge tables containing numerous numbers of rows for better performance.

Scripting the Database Consistency Checks (DBCC), scheduling the scripts to run daily and weekly basis.

Successfully implemented physical standby database using Oracle 11g Data Guard feature for High availability and Disaster Recovery purpose.

Installed and configured 2 node oracle 11gR2 RAC with ASM on Linux RHEL 6.1 for production environment.

Identified index fragmentation and rebuild of indexes.

Applied relevant patch set updates (PSU) on Oracle databases and interim patches for various bug fixes on database products.

Actively involved in monitoring the lock processes, releasing locks in case of resource blockage and gathering Statistics.

Wrote shell scripts for automation of tasks and used shell scripts with crontab for job scheduling.

Contacted various users in gathering the requirements and documented the necessary changes.

Created necessary templates for various requirements gathering and documentation.

Monitored Log shipping and Transactional Replication and troubleshooting of errors.

Environment: SQL Server 2012,2008r2, SSRS, SSMS, SQL Profiler, Performance Monitor, Microsoft Excel, Oracle 12C/11g, Oracle Enterprise manager 12c, RMAN, DataGaurd, RAC, SQL developer

Database Engineer

Finastra, Bangalore-June/2011 to Jan/2015

Finastra is one of the leading Banking software industry with more than 2,000 customers across 125 countries, its solutions cover retail and corporate banking, lending, treasury, capital markets, investment management and enterprise risk. We are the team of 12 members DBA team, responsible to support various RDBMS databases which includes Oracle, SQL-SERVER, IBM db2, as400 on various Operating systems.

Responsibilities:

Provided ongoing support for MS-SQL and Oracle database servers which include Installation, configuration, Upgradation, Migration, Maintenance and Troubleshooting.

Created alerts, notifications and emails for system errors, insufficient resources, database, hardware, and security errors.

Configured and Managed the High Availability and Disaster Recovery Solutions, Mirroring, Replication, Active-Active and Active-Passive Clustering on Critical Production Servers.

Scheduled the database backups and recover the databases from backup in disasters using Point-In-Time Recovery solutions.

Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.

Encrypted data and log files using transparent data encryption (TDE) solution.

Created and Scheduled jobs, alerts jobs to capture any possible errors.

Migration of Oracle Databases from NON-RAC to RAC and NON-ASM to ASM.

Installation and creation of Oracle10g, 11g Databases for production, test, dev servers.

Implementation and support of Oracle 11g and 12c migrations and upgrades from Oracle 11g to 12c database.

Set up Disaster Recovery using DataGaurd physical standby databases for mission critical Oracle databases.

Implemented snapshots on a separate instance to use it as a reporting server minimizing load on production using DataGaurd.

Tested Oracle 12c regression testing prior to production implementation for a 900GB oracle DB.

Performed database tuning using Explain Plan, Tkprof, Statspack and other custom utilities.

Used Oracle 11g/12c AWR & ADDM to monitor database activities and performance tuning.

Provide support for 12c Oracle Enterprise Manager Grid Control and Agents.

Maintain, schedule and troubleshoot all RDBMS related software Oracle Enterprise Manager (OEM) Cloud Control 12C on Linux and Unix Environment.

Responsible in configuring and backing up database using RMAN, Hot backups, Cold backups and Logical backups.

Worked on Flashback to restore on point in time recovery.

Restored/Refreshed downstream Oracle database instances for various DEV, QA and UAT purposes.

Managing Tablespaces, Data files, Rollback segments, Temporary TBS.

Proficient in using Flashback technology, Log Miner, Automatic Storage Manager.

Maintain, upgrade, troubleshoot all Enterprise oracle and SQL server databases

Clear communication and documentation of technical specifications.

Used Jira and Confluence tools for Issue tracking.

Environment: Oracle12c/11g, SQL server 2012/2008,SSMS, RAC, Datagaurd, Datagaurd broker SQL, PL/SQL, RMAN, ADDM, AWR, ASM, Stats pack reports, Shell Scripts, SQL Developer, RHEL-6.3/6.4, Windows server 2008r2, Jira, Confluence, SVN, Eclipse IDE, Perl scripting, Shell scripting

Jr. DBA

Allscripts, Bangalore-Sep/2009 to May/2011

Allscripts is leading the healthcare IT providing solutions to enable smarter care, delivered with greater precision, for healthier patients, populations and communities.

Responsible to Install, Configure and maintain SQL-Server 2008R2 on test and development servers.

Performing backup and recovery

Implement and maintain database security.

Troubleshoot and minimize production down issues.

Running DBCC consistency checks, and fixing data corruption in application databases.

Monitor failed and long running MS SQL Server jobs

Responsible to both manage and support oracle databases with sizes varying from 50 GB to 500GB.

Installed and Upgraded 10g to 11g.

Perform daily administration support for database backups, performance tuning and monitoring.

Created User accounts, Roles and granting required access permissions and privileges to the database based on the applications they are accessing.

Worked on Data pump to take the logical backups of databases.

Worked on performing Point in time recovery using RMAN.

Used oracle configuration assistants like DBCA (Database Configuration Assistant) for Creating databases, DBUA (Database Upgrade Assistant) for Upgrading databases and NETCA (Network Configuration Assistant) for creating a Client-Server environment using Listener, TNS names etc.

Storage Management Managing Space, Tablespaces, Segments and Extents, Rollback Segments & Data Dictionary. Online/Offline Database Backups and managing database recovery with RMAN.

Performance tuning via OEM, STATSPACK/AWR for 10g/11g.

Maintenance tasks like bouncing the production database, services through Veritas.

Installed IBM db2 database on AIX servers

Worked extensively on Clustering and server consolidation. Troubleshooting production issues and raising high availability.

Environment: Windows server 2008 R2, SQL Server 2008R2, Oracle 10g, Jira, SQL Developer, Enterprise Manager, batch scripting.

Certification: ITIL certified

Education: Bachelor’s in Computer science and Engineering

Contact this candidate