KIRAN PRASAD MAALE

adgy5u@r.postjobfree.com

Mobile: +1-646-***-****

LinkedIn: https://www.linkedin.com/in/kiran-maale-3a113211/

PROFESSIONAL SUMMARY

13+ Years of extensive experience SQL Server DBA and Microsoft Azure.

Configure SQL servers in Azure Iaas in installation, configuration, Migration and implementation of SQL Server 2017/2016/2014/2012/2008R2/2005 on stand-alone and clustered instances and extensive experience in Azure.

Good Knowledge of Oil&Gas, Gaming Development, Microsoft IT Products, and Entertainment Network.

Proficient in dealing with Windows Azure – Compute, Networking, Storage, Security, Identity, Developer Services, Monitoring and Management.

Expertise in Virtual Networks, Virtual Machines, Azure Cloud Services.

Expert in and migrating managing on premise applications to Azure.

Handled more than 1000 VM's in Public Cloud Azure Infrastructure in Deployments and Configuration Upgrades across Azure platforms and sub components with new builds and releases.

Experience in DBAAS migration in Microsoft Azure cloud using DMA and storage explorer.

Extensive experience in Migrating the sql server databases to Windows Azure (Iaas) servers. creating VMs, Installation, configuration and set up same like on premise servers and migrating the databases to Azure.

Creating backup schedules in Azure Iaas and configure to recovery vault.

Restoring the databases from Azure Recovery Service Vault to SQL VMs.

Experience in Database Encryption (TDE) in Azure Iaas databases.

Experience in Backup/ Restoration/ Recovery and Export/ Import of SQL Databases.

Extensive experience in Building, designing and implementing High Availability (HA) and Disaster Recovery (DR) solutions like Clustering, log shipping, Replication, Mirroring and Always ON high availability Groups.

Extensive experience in setup WSFC for SQL server Failover clustering.

Extensive experience in SQL server Upgrades and Migrations from SQL 2000 to 2005/2008R2, SQL 2005 to 2008R2, SQL 2008R2 to SQL 2012 and SQL Server 2012 to SQL Server 2014/2016 side by side.

Extensive experience in managing DBA activities and critical projects to meet/exceed Service Level Agreements (SLAs).

Very extensive knowledge on Query Optimization, Tracing, Tuning, Designing Activities.

Experience in windows monthly patching and SQL patching (CU).

Experience in Creating and Removing Indexes, Troubleshoot the existing poor performance Queries and recommend the fixes.

Experience in query optimization & performance tuning; SQL Profiler, Execution Plans, Performance Monitor (Perfmon), DMVs and DBCC Commands.

Experience in developing SSIS packages using Visual Studio Development tool.

Experience in using SSIS (SQL Server Integration Services) for data extraction, transformation and loading across different databases like Oracle, MS Access and flat files using tools like Import and Export Wizard, Package Installation and SSIS Package Designer.

Experience in designing and implementing SQL Server Reporting Services (SSRS) and creating SQL Server Reports.

Experience in creating SQL objects like Tables, Stored Procedures, Views, Indexes, and writing ad-hoc queries for data analysis.

Experience in designing and developing SSIS packages for automating DBA Tasks such as Migrating the logins in Always on servers.

Experience leading offshore teams to deliver mission critical projects on time.

Experience in capacity planning, SQL patch upgrades (Service packs and Cumulative updates) by coordinating with the application teams.

Extensive experience in change management process; Collaborating closely with developers, application owners and infrastructure staff in promoting development code to UAT for user acceptance testing and release in production for validation and user sign off.

Extensive experience in SQL Azure Deployment in Production and Testing.

TECHNICAL EXPERTISE

BACKUP AND MANAGEMENT TOOLS: Azure Management portal, Azure Recovery Service Vault, Azure Storage blob and Light speed tool.

MONITORING TOOLS: SCOM, Redgate, Fog light, and SiteScope.

TICKETING TOOLS: Remedy and ServiceNow

DATABASES: SQL Server 2017 to 2005

MS DEVELOPMENT TOOLS: SSMS, DTS, SQL Profiler, SSIS, SSRS and Import/Export Wizard.

Reporting Tools: Power BI and SSRS

OPERATING SYSTEMS: Windows Server2016/2012R2/2008R2/2003/Advanced Server, Windows 98/XP/Professional.

PROFESSIONAL EXPERIENCE CHEVRON

Jan ‘16 – Present SAN RAMON

SQL Server DBA

Chevron Corporation is an American multinational energy corporation. One of the successor companies of Standard Oil, it is headquartered in San Ramon, California, and active in more than 180 countries. Chevron is engaged in every aspect of the oil, natural gas, and geothermal energy industries, including hydrocarbon exploration and production; refining, marketing and transport; chemicals manufacturing and sales; and power generation. Chevron is one of the world's largest oil companies; as of 2017, it ranked nineteenth in the Fortune 500 list of the top US closely held and public corporations and sixteenth on the Fortune Global 500 list of the top 500 corporations worldwide.

Responsibilities:

Implemented SQL Server 2008R2/2012 Active/Active, Active Passive cluster on Windows 2008R2/2012 cluster, to setup Production & UAT environments and Standalone installation to set up SIT and DEV environments.

Implemented Always on High availability & Disaster Recovery solutions. Implemented Hybrid always on High availability & disaster Recovery solutions.

Configured\Monitored\Supported and Troubleshooting of Database Mirroring and Log Shipping for multiple databases on Geo-graphically separated cluster environments to provide High Availability and Disaster Recovery. Support and troubleshooting for Transactional replication.

Created Maintenance Plans to checking database integrity, rebuilding indexes, and updating statistics. Designed and implemented backup plans as per the data- retention policy.

Worked in co-ordination with different teams (Application, Active directory, Engineering & QA) to support Deployments/New Application Rollout’s/Month-end, Year-end deployments, and Change Requests.

Deployed SSRS reports and granted appropriate roles and permissions.

Based on request implement SSIS packages and debug issues with SSIS Packages.

Work on Dead lock, blocking issues proactively on servers and identify the root cause.

Planning\Implementation and supporting storage upgrade activity in SQL Server Cluster Environment.

Migrating\upgrading the databases to newer version of sql server (2008 -> 2012/2014/2016/2017) on prem and Azure Iaas.

Managing Security of SQL Server Databases by creating Server Logins, Database Users, Roles and assigning permissions in compliance with standards and resolving issues by coordinating with Active directory Group.

Routine tasks: Monitoring and Maintaining the security, integrity and availability of Servers, monitoring SQL Server logs, jobs and database backups, performance tuning, building packages and responding to users and developer issues.

Sep ‘14 – Dec 15 A&E

SQL Server DBA NYC

Arts and Entertainment Network (A&E Television Networks, LLC) is truly a global media company with joint ventures and channels all over the world. In addition to its New York headquarters, A+E Networks has offices in London and Singapore. The International division oversees 50 channels around the world, reaching more than 300 million subscribers in over 150 countries in 37 languages.

Responsibilities:

Installation and Uninstallation of SQL, SQL related components, upgrade, configuration, tuning and patching of the MS SQL Server database software on all Hosted servers.

Deploying the change requests such as application level & Database level enhancements.

Take care of the Server/Database design and implementation as part of new Installation.

Setup and Managed Mirroring, Clustering and Log shipping (SQL Versions 10.0-14.0)

Worked with end users to define, implement, and maintain reporting requirements.

Configured the physical design of the database by implementing a flexible architecture compliance

that suites both OLTP and data warehouse applications.

Implemented Change management controls, processes, and practices to deliver quality services that

increase client bottom line results.

Engaged in various DR(Disaster Recovery) efforts with Always On, Clustering and Log shipping.

Developed problem tracking apps that assigned all related system errors/problems to appropriate database and/or application personnel using 3rd party tools(Idera/Commvault).

Performed Schema Changes in development instances and migration to prod environment.

Building and implementing of SQL Always On, Add and Remove of AG Replicas which involves change of Listener dropping/creating and rename.

Daily Operations include: Daily Server Health check, Backup & Restore Status, DB Mirroring

Health Check, Disk Space, Log File Status and Usage, Monitoring Application related Jobs & Performing Database Refresh’s.

Jun ‘11 - Aug ‘14 Electronic Arts

SQL Server DBA India

EA, India

Electronic Arts (EA) is the world's leading independent developer and publisher of interactive entertainment software.

Responsibilities:

•Installation, upgrade, configuration, tuning and patching of the MS SQL Server database software on all Hosted servers

•Take care of the Server/Database design and implementation as part of new Installation.

•Scheduling and execution of all database Backups and Restorations, ensuring proper retention and cleanup of previous backup files. Identification and resolution of all errors during execution. Integration of automated error notification.

•Performing upgrades and migrations of the database and software to new release levels

•Implementation and Monitoring of Database Mirrored Databases.

•Monitoring and administration of Clustered databases.

•Good Experience in Performance tuning like slow running queries, Fragmentation and re-indexing the fragmented indexes, placing server-side traces, enabling profilers and perfmon to capture performance related issues.

•Creating, maintaining, and documenting the data model. This includes the proper use of indexes and constraints to ensure the integrity of the data.

•Collaborated with BI teams in the full development lifecycle of SQL Server 2008 and latest versions of enterprise Datawarehouse’s and report servers.

•Developed, modified, and optimized complex stored procedures, triggers to handle complex business rules, history data and audit analysis.

Environment: Windows 2008/2003/2000 Server, MS SQL Server 2008R2/2005 Business Intelligence Development Studio, T-SQL, Idera Diagnostic Manger and other Idera tools and SQL Profiler.

Sep ‘06 - Aug ‘11 Microsoft, India

Junior SQL Server DBA

RxD - MIO Microsoft Individual and Organization (MIO) is an enterprise platform that masters all organization, individual and contact preference data that is core and common across all Microsoft IT applications. MIO is the only place to get accurate, authoritative, and enterprise-wide organization and individual information. Line of Business (LOB) applications augment MIO’s core profile with their own mission-specific data.

Responsibilities:

Supporting more than 45 Production and Pre-Production servers to ensuring their high availability.

Monitoring jobs, troubleshooting on failure, and addressing alerts. Verify backups and error logs on the servers and troubleshoot on any failures or alerts.

Checking the status of Backup jobs and troubleshooting the failed backups and Restoration of databases. Implementation of Logins, creating Users, assigning responsibilities as a part of Security Policies for various categories of User Support.

Making data available to all the resources using the Log Shipping periodical troubleshooting of customer data issues.

Having work Experience on Database Mirroring and Log shipping. Automating the DBA tasks using Database maintenance wizard, Alerts, Jobs and SQL mails.

Involved in the monthly security patching exercise in both UAT and PROD servers. Monitored lock Escalation, Dead Locks, resources utilization by sessions, capturing long running SQL queries.

Configured database mail profiles for sending automatic mails to respective users upon the success or failure of a database task. Created SQL Server traces using the SQL Server Profiler for optimal performance monitoring.

Actively involved in password maintenance tasks for SQL/Web/Cluster accounts. Taking backups from production servers and restoring them on PPE & dev servers Environment.

EDUCATION

M.Sc. (Cs) Computer Science, from Osmania University.

B.Sc. (Cs) Computer Science, from Osmania University.

Higher Diploma in Software Engineering (HDSE), Aptech.

Contact this candidate