Резюме DBA

Pune, MH, India 411057

+ Показать контакты

***************************** (mailto:*****************************)

*********************

My approach to contrasting challenges in life is reflective of the
quote, 'If you want something you’ve never had, do something you’ve
never done'. Seeking a challenging opportunity to continue trend of
success in leading projects that optimize organizational efficiencies,
increase user satisfaction and maximize bottom line contributions.

***** Kothari

Senior SQL server DBA

Seasoned DB specialist | Strategic Data Management| Database Analytics

linkedin.com/in/*****-kothari-9a543527/

Summary



A dynamic professional with 10 years of industry experience
in database development and administration



Team player with outstanding leadership skills and ability to

deliver critical assignments on/before time.



Good knowledge of SAN, NAS, SSD, RAID/Striping



Adaptable to SQL based Unix environment



Customer site (onsite) working experience and proficient in
implementing transition plans.



Certified in ITIL foundation



Business Visa: B1/B2 Visa (United States of America)

Experience

Associate Architect

iCertis

Feb’16 – Present

Design, model and implement database components to support product

features that address complex business problems and are secure,

scalable, robust and easy to implement and maintain.

Reports to: Senior Manager – Database Engineering



Understand complex customer scenarios and help them to
address through existing or customized product features.



Prepare use cases and write tests & tooling for those features to

ensure they work well



Work with DevOps, Product and Solution Engineering Team for

Database Deployment, Fine-tuning, Query optimization, develop 

SQL Stored Procedures, support deployments for customers as 

and when necessary. 



Help customer in risk assessment and preparing smooth 

transition plans to bring mature processes. 

Skills 

Technical 

Data security, Backup and recovery 

Log shipping and replication 

Always ON and Failover clustering 

Performance tuning 

SSIS, SSAS, SSRS 

Capacity planning 

Database design and modeling 

Third party tools 

Migration and upgrade planning 

Cloud integration (Dell Boomi) 

MSSQL development 

SQL server encryption 

AWS RDS, EC2 

 
Specialist Database Administrator 

NICE Systems (NASDAQ: NICE) 

Sep’16 – Feb’19 

Key member of the Advanced Support Group.
Working as L3 SQL database administrator. 
Direct and coordinate all activities and applications related to 

maintaining and refining business intelligence components such as SQL 

servers, integration, analysis and reporting services (SSIS, SSAS and 

SSRS).

Reports to: Global Deployment and Infrastructure Manager 



Designed and supported High Availability/DR Techniques such 

as Clustering, Mirroring, Replication and Always ON in SQL 

server *********************. 



Automation and standardization of SQL Server environment to 

operationalize repetitive tasks.



Extensive experience as Production support SQL Server 

Database Administrator 



Worked on installing, maintaining and tuning the performance of 

large, high volume and high criticality SQL environments. 



Analyzing and correcting issues with backups, TSQL code, 

database corruption, and security. 



Performance tuning and optimization including the server, 

stored procedures, and queries through native and third party 

tools. Perform query plan analysis optimize inefficient queries. 



Write and deploy SQL stored procedure, functions and other 

programming objects. 



Maintain VLDBs and optimize for smooth data loading & 

recovery. 



Perform and maintain best practices for database maintenance 

(Index 

and 

file 

management, 

statistics, 

database 

defragmentation).



Monitoring & troubleshooting the High CPU, Disk Space usages, 

Procedure Queue Length and Disk Queue Length through Splunk, 

Redgate SQL monitor, Quest Foglight and provides the 

recommendations and solutions. 



Configure change data capture and other database auditing 

techniques. 

 
Enterprise Database Engineer 

ZS Associates (One of top 10 Consulting firms) 

Mar’13 – Sep’16 

Reports to: Associate principal (IT) 



Installation, Configuration and Maintenance of Microsoft SQL 

Server 2012/2008R2 on Standalone, Cluster servers and AWS 

servers according to the Clients / Project requirement. 



Providing pre- sales cost analysis for SQL environments. 



Capacity planning for Disks and Space Management Database 

files. 



Security Management for Windows\SQL server Logins and 

assigning appropriate access rights. 

 
Open source (Postgres SQL, MongoDB) 

 
Education 

B. E. (Computer Science) 
University of Rajasthan 

2004 –2008 

 
 
Recognition 

 

Spot award from NICE system

 

Recognition award from ZS Asscoates 

 

Appreciation for good work from BoB 

 
 
 
Recommendations 

“I had chance to work with ***** for two years. 

He is extremely professional in Database 
Administration and highly qualified in 
troubleshooting. Always helpful, immensely 
smart and analytic with his knowledge and you 
can feel his fast and responsive character on 
any case. 
***** is proactive, responsible, result oriented 
and never gives up for any issue which he 
encountered with his amazing patience. 
I would strongly recommend ***** for his 
professionalism and he's also a pleasure to work 
with a second time.” 

~ Ertunc Varol, Application Consultant- 
Customer, Verint 



Monitoring & troubleshooting the High CPU, Disk Space usages, 

Procedure Queue Length and Disk Queue Length and provides 

the recommendations and solutions. 



Bulk Insert, BCP Utility and DTS, SSIS packages for data transfer 

activities. 



Monitoring and troubleshooting the Blocking, Deadlocks, login 

failure, disk space, backup jobs, maintenances jobs which helps 

the daily work to run faster and in timely fashion 



Providing solution for Database migrations and Server upgrades, 

Logins transfers for End to End Server Migration. 



Core database activities like Shrinking Database, Attach-Detach 

Database, Import-Export database, adding files, suspect 

database, migration, linked server etc.



Creating and configuring Boomi (dell integrator tool) processes 

for synchronizing cloud and enterprise environment. 



Analyzing query plans and performance optimization of OLTP 

and reporting queries over 6 TB databases. 

Database specialist 

Tieto Software technologies 

Jun’11 – Feb’13 

Reports to: Project manager 



Creating Databases, Batches, Jobs, Maintenance plan, 

Transactions etc… 



Database Backups, Configuring SQL Mails, Clustering, Data 

Security etc. 



Implementation, Monitoring and Troubleshooting database 

jobs, space issues, 



Database Migration between production, development and UAT 

servers. 



Installation, Upgrade and Patch management. 



SQL DBA Activities, User creation, Granting Permissions, 

Creating Roles etc. 



SQL Server Authentication and Windows authentication DB 

Security. 



User creation and security management. 



Back and Restoration. Monitoring SSIS packages.



Log shipping on SQL server 2005, Mirroring on SQL server 2005



Database Backups & Restore 



Shrinking Database, Attach-Detach Database, Import-Export 

database etc.



Database Performance Monitoring, Monitoring Expensive SQL 

Statements



Database tuning advisor, Graphical Execution plan, Profiler, 

Performance Monitor etc. 

Senior software engineer 

HCL Info systems/ Bank of Baroda 

Jan’11 – May’11 

Reports to: Senior Data Center Manager (BoB)



Handling the Backup / Restore jobs and user request 



Data Replication. 



Installing, Managing, Maintaining & Configuring Microsoft SQL 

Server 2005 Databases 



Troubleshoot replication and clustering problems. 



Daily monitoring and generating performance reports. 

“I had the pleasure to manage ***** during his 
tenure in NICE.
***** is very professional, knowledgeable, 
cooperative and reliable. 
I used to work with ***** daily and he often 
served as my go to employee in many 
scenarios. 
I knew that every complicated task I have for 
***** will be resolved in no time. 
He has intelligent insights and he often 
contributed to the team effectiveness. 
He has exceptional communication skills and is 
a real team player! 
I highly recommend ***** and would be happy 
to provide additional feedback personally.” 

~ 

Tali Gomelsky, Technical Support Manager, 

Varonis

“***** as a Database specialist was a key 
resource in my Application development and 
Business intelligence group. He had a great eye 
for details, was patient and a good listener. He 
was the go to guy for the newer associates 
within these two groups and for new projects to 
help us frame the architecture from a database 
design and development standpoint. ***** also 
had strong communication skills and he 
participated in many of our client discussions at 
critical stages of the project. I strongly 
recommend ***** for any Database design, 
development and architect positions. He is an 
asset to the organization.” 



Managing and Troubleshooting Database issues. 



Monitoring and Troubleshooting database jobs. 



Troubleshooting database issues Blocking, Deadlock, High CPU 

problem, Memory etc. 



Implementing and Troubleshooting Database maintenance 

activities Rebuild Index, Update Statistics etc. 



SQL Server Authentication and Windows authentication DB 

Security 



Shrinking Database, Attach-Detach Database, Truncate log file, 

Import-Export database etc. 

Software engineer 

Nav Backoffice IT Solutions Jul’08 – Jan’11

Reports to: IT manager



Write procedures to implement portfolio data checks on basis of 

accounting principles and implementation of database email 

configuration for critical checks.



Implementation of standard and customized reports for clients 

to show risk and performance figures on daily and monthly basis. 



Write stored procedures to generate risk and performance data 

of client based on client trading portfolio. 



Write reporting stored procedures and VBA programmed 

macros for excel reports.



Implementation of major modules in parsing utility which 

converts report style text files into delimited readable format.



Standardization of reading configuration.



Write data fetching, validating, customizing and saving stored 

procedure system. 

~ Sai Prakash, Senior Director & Country 

Manager, SunGard Availability Services