RESUME

VIJAYA KUMARA N

S/o P. Narayanappa.

Kanagamakalapally (V),

Mittemary (P),

Bagepally (T), Chikkaballapur (D), Email: adlq33@r.postjobfree.com Karnataka PIN-561207 Cell: +91-897*******

CAREER OBJECTIVES:

To utilize my knowledge towards a challenging career in a growth-oriented, leading organization where professionalism and perfection are respected and which will provide ample opportunity for continuous growth and advancement.

Summary of Experience:

Possessing 4 years 9 months of vast experience in the field of IT solutions and SQL Server DBA, in SQL Server 2008R2/2008/2012/2014/2016. Install and configure,(Standalone/cluster), Replication, SQL Server Administration, High Availability (HA) and Disaster Recovery (DR), Backup and Recovery

( Data, Data and Schema ), Jobs Creations, Stored Procedure, Changing Scripts, Table Creations, Users Security, Authentication, DB Capacity Planning, Troubleshooting, Application Testing, Windows Server 2012 R2(Installation and Configuration), Basic network and connectivity. Expertise:

MSSQL Server 2008, 2012,2014,2016,2017 versions Installation and Configuration (Standalone / Cluster) based on the Required Services.

Managing MSSQL Server- User Permission (Reset/Change of password for MSSQL Authenticated IDs), DB Creation, DB Replication, DB Migration.

MSSQL Backup and Recovery – All types of backups.

Monitor and Management of database replication to other instance /DR sites.

On High Availability – Failover cluster.

Creating and Modification in Stored Procedure based on the requirement of Application (At the time of customization).

Based on the Application requirements on- site, need to change the procedure scripts.

Capacity Planning how large the database currently is and how fast it is growing to make predictions about future needs.

Wildfly and Tomcat Server Readiness for war file Deployments.

Excellent Troubleshooting Skills.

Escalation to Database Lead for any issues and critical matter.

Able to work independently and within a team spirited-environment.

Strong presentation skills.

Fantastic ability to learn New Materials Quickly. Work Experience:

Company : Capgemini Technology solutions India Ltd. Client Location: AXA Health [ME, NE, ASIA]

Designation : MSSQL Database Administrator.

Job Responsibilities:

4+ years of experience in Database Administration, Database Design, Development & support of MS SQL server 2008R2/2008/2005/2000/2014/2016/2017 in Production & Development environments. (Standalone and Clustering)

Managing Windows Server Infrastructure 1800 database servers.

Performed Implemented replication as High Availability Techniques.

Responsible for creating tables, views, dynamic stored procedures, user defined functions and other Transact –SQL (DDL, DML) statements for various applications.

Worked with SSIS & SSRS for various BI requirements.

Experience in SQL server replication, Backup/Recovery, Disaster recovery and planning.

Responsible for handling backup and recovery for a third-party tool like TSM and TDP.

Tracked server activity, query performance and disk usage activity statistics via performance data collection.

Experience in performance tuning, query optimization, client / server connectivity, database consistency checks using DBCC utilities.

Expert in automating process by creating jobs, and error reporting using alerts.

Experience in creating of logins, users and configuring permissions and assigning roles to users.

Experience in database backup and disaster recovery procedures.

Worked extensively in clustered environment to further increase scalability and stability of business critical systems.

Development of automated notification when SQL server backups and schedule maintained jobs.

Expertise database design, performance analysis, and production support for larger and complex databases up to 2.7 TB.

Experience in optimizing the query by creating various clustered, non-clustered indexes and indexed views.

Experience in creation of logins, users and configuring permissions and assigning roles to users.

Responsible to create stored procedure as per the user requirements.

Perform patching to maintain current version of SQL.

Responsible for handling incidents, requests, and changes.

Responsible for monitoring SILVA ticketing tool to take action on high priority (P1) incidents and changes. (For all three regions ASIA, ME, NE)

Responsible for prepare pre-requisites for changes before the change window starts.

Responsible for prepare P1 incident chronology and RCA.

Support for development environments refreshes of UAT/Staging /Pre-prod environment.

Monitoring the CPU usage, IO statistics, and memory usage to identify any OS level performance by using SCOM alerts.

24x7 production database on call support. Excellent analytical, problem solving and communication skills.

Academic Qualification:

BE in Computer Science, Nagarjuna College of Engineering &Technology Bangalore under VTU in 2012. Aggregate - 58.77%.

M Tech in IAR, Karavali Institute of Technology Mangalore under VTU in 2016. Aggregate – 76.52%.

Professional Experience: Major Assignments:

Jun 2017 – Dec 2019 – Trinity Mobility.

Project: CAD Application.

Client: Police Dept.

Environment: MSSQL, Wildfly, Tomcat.

Role: Database Administrator.

Aug 2016 – May 2017 – STI

Project: Backup and Recovery

Client: Bosch in electronic city phase II.

Environment: Backup and Recovery.

Role: Technical support engineer.

Technical Skills:

Windows Server and Hyper-V (Windows 2003, 2008, 2012 R2).

SQL Server DBA, in SQL Server 2008R2/2008/2012/2014/2016.

MSSQL installation and configuration. ( Standalone / cluster)

Well in DDL, DML, DCL, TCL Command, Joins, index, function.

High Availability (HA) and Disaster Recovery (DR),

Backup and Recovery (Data, Data, and Schema),

Jobs Creations, Stored Procedure.

Changing Scripts, Table Creations, Users Security, Authentication,

Tomcat & Wildfly .war Servers readiness.

Good at Presentation and Communication skills.

Languages: C, C++, HTML, T-SQL, Stored Procedures, RDBMS. PERSONAL PROFILE:

NAME : VIJAYA KUMARA.N.

FATHER'S NAME : NARAYANAPPA.P.

DATE OF BIRTH : 20/10/1988.

SEX : MALE .

NATIONALITY : INDIAN.

JOB STATUS : 4 Year 9 Months.

Languages known:

To Speak : Kannada, Telugu and English.

To Write : Kannada and English.

To Read : Kannada and English.

DECLARATION:

Whatever stated above is true to the best of my knowledge belief and information. Place: Signature

Date: (VIJAYA KUMARA.N)

Contact this candidate