NIKITA SONI

Sunnyvale, California / USA +1-650-***-**** adxyg5@r.postjobfree.com linkedin.com/in/nikita-soni7 EXPERIENCE SUMMARY

• Over 6+ years of total professional experience with SQL Server DBA, in Retail and Consulting environments.

• Expert in RDBMS concepts and constructs to design relational database model and implementation as per business needs.

• Solid experience in Installation, Configuration, Migrations, Administration, of SQL Server 2008R2/2012/2014/2016/2019.

• Configured Active/Active and Active/Passive clustering for failover.

• Proficient with Database Backup, Recovery Procedures, Database Design, using various tools.

• Experienced in writing T-SQL (DDL, DML, and DCL) & debugging. Reviewing T-SQL code, maintaining coding standards in all SQL Server environments.

• Extensively worked on 32 bit and 64 bit clustered and standalone server environments.

• Experienced in deployments.

• Team player with strong interpersonal skills. Zeal to learn new concepts with excellent communication skills with management, developers, and systems administrators

• Competent to work at the highest level of all phases of database management

• Ability to handle multiple projects with a good grasping knowledge in understanding the business.

• Experience in infrastructure and operations and in cloud network infrastructure in Azure. ACHIEVEMENTS & CERTIFICATIONS

• Got Four certificates of Excellence-Bravo Award; as a shining star by IBM.

• Cleared IRDA (Licensing of Insurance agent) paper.

• Worked for paid internship of 8 weeks on an International Project for GES-Australia as Research Analyst Intern.

• Got certificate for successful completion of Global Immersion Programme in Nanyang Business School, Singapore.

• Received Silver medal by obtaining 2nd position in MBA Programme in the year 2017.

• IBM Agile Explorer Certification Date Sep 2017 - Present License LT-3469,LT-3538.LT-3563

• Big Data 101 Certification License BD0101EN

• Blockchain Essentials Certification License BCO101EN

• Introduction to Data Science Certification License DS0101EN SKILLS INVENTORY

Relational Databases: SQL Server

Operating Systems: Windows, UNIX/Linux, MS SQL Management studio, Databases, Backup & Recovery, SQL server Programming Languages: C, C++, java basics, web programming, Basics-MS Office (Word, Excel, Power-Point Client relationship management)

Database Tools: MS SQL Management studio, Backup & Recovery, SQL server. Design Tools: SCCD/ISM/Maximo Service now, IBM Lotus Notes, Mainframe, VMware, Active Directory, SAP, Robotic Process Automation (RPA). Automation Anywhere partner Portal Access Microsoft (Word, Excel, Powerpoint, Project, Internet Explorer), SharePoint Networking Tools: TCP/IP Protocols.

ETL Tools: SSIS, SSRS

PROFESSIONAL (OR PROJECT) EXPERIENCE

Kyndryl

SQL Server Database administrator, CA, USA November 2021 – Till present Ernst & Young (EY)

PROJECTS:

End of line - SQL2012EOL

• This project is an EY Global/Enterprise-Wide Program.

• Upgraded all SQL2012 Servers to SQL2019(or other versions as per the requirement) & migrated before June 2022.

• Identified the servers on decommission queue & drove them to decommission cycle. BAU

• Performing DBA task on daily basis.

• Check System Event Logs and SQL Server Error Logs for unusual events.

• Verify that all scheduled jobs have run successfully. NIKITA SONI

Sunnyvale, California / USA +1-650-***-**** adxyg5@r.postjobfree.com linkedin.com/in/nikita-soni7

• Confirm that backups have been made successfully and moved to the backup storage or secure location.

• Monitor disk space to make sure SQL Servers will not run out of disk space.

• Periodically monitor performance of database and system using both System Monitor and SQL Server Profiler.

• Monitor and identify blocking issues.

• Keep a log of any changes you make to servers, instance setting, database setting and monitoring script.

• Create SQL Server alerts to notify you of problems, and e-mailed to you. Take action as needed.

• Regularly restore backups to a test server in order to verify that you can restore them. IBM

SQL Server Database administrator

Ernst & Young November 2019 – November 2021

• Responsible for the physical and technical aspects of a database systems.

• Responsibilities of this job role include, but are not limited to, installation and maintenance of the database system, installation of upgrades and patches, performance and capacity monitoring & management and security compliance.

• Potential interaction with clients internal or external in order to understand and meet requirements for the delivery of services related to database products.

• Manage SQL Server databases through multiple product life-cycle environments, from development to mission-critical production systems.

• Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.

• Apply data modeling techniques to ensure development and implementation support efforts meet integration and performance expectations Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end Refine and automate regular processes, track issues, and document changes. Delhaize November 2016 – November 2019

• Delhaize Group is a food retailer headquartered in Anderlecht, Brussels, Belgium which operates in Eight countries and on three continents. The principal activity of Delhaize Group is the operation of food supermarkets. IBM supported Delhaize North America.

• Support database environment with the agreed service levels, also to ensure the maximum availability of servers by taking timely action and proactive measures as and when required, IBM SQL team will provide the 8X5 (EST Prime hours) support model and on-call will be engaged during off business hours for the Sev1 and Sev2 incidents and during any MI.

• First Level Support: IBM Monitoring Team provides the first level support 24/7. Alerts will be analyzed and ticket will be raised if required.

• Second to Fourth Level Support: SQL Server Team provides the second to fourth level support 8X5; all the SQL related incidents will be handled. If there is major issue or assistance required form vendor, then SQL Database team will create support incident with respective support vendors.

• Weekly replication Validation Report.

• Support windows patching and health check

• Worked on RU report which was monthly activity.

SYSTWEAK SOFTWARE

Trainee database administrator March 2016- November2016

• Systweak Software is an IT solution company based out of India.

• Providing business solutions to clients, system optimization utilities and outsourcing services, enabling its clients across the globe to transform and perform through technologies.

• Worked on database administration task like creating backups, restoring backups, Monitoring disk space to make sure SQL Servers will not run out of disk space which are agnostic of the underlying database technology. GLOBAL EDUCATION SOLUTIONS(GES)

Research Analyst Intern April 2014

• Online research work from anywhere if you have an internet connection and a laptop/desktop.

• Work involved extensive research and analysis on occupations, jobs and industries in India to develop exhaustive knowledge and insights on occupation.

• Constructing a learning portal with educational contents. NIKITA SONI

Sunnyvale, California / USA +1-650-***-**** adxyg5@r.postjobfree.com linkedin.com/in/nikita-soni7

• Edit Knowledge Base articles for completeness, style, and accuracy to ensure it reflects GES commitment to quality.

• Ensure timely availability and search-ability of highly technical documents.

• GES Knowledge Base for our customers.

• Review the content consumption by customers and devise strategies to ensure better adoption. ADDITIONAL

TECHNICAL SKILLS:

• SCCD/ISM/Maximo Service now, IBM Lotus Notes, Mainframe, VMware, Active Directory, SAP, Robotic Process Automation (RPA). Automation Anywhere partner Portal, Good capability of understanding of internet, High degree of analytical and problem-solving abilities and Ability to work with minimum supervision

• Adequate knowledge of C, C++, java basics, web programming, Basics-MS Office (Word, Excel, Power-Point Client relationship management, Business Analysis, Experience in various operating systems such as Windows, UNIX/Linux, MS SQL Management studio, Databases, Backup & Recovery, SQL server, cloud network infrastructure in Azure. EDUCATION

GRAPHIC ERA UNIVERSITY

MBA, Finance & Business Analytics & 8.7/10 GPA 2013-2015 B.TECH, Information Technology & 81.34% 2009-2013

Contact this candidate