Amar Nath

SQL DBA at Angel Broking Pvt Ltd.

• India - Mumbai
• My current job since October 2012

Installation, up gradation, service packs patching of sql server.
Writing sp and function.
Writing and Optimizing stored procedures, triggers and functions.
Performance optimizing and monitoring through tools like sql server profiler, database tuning advisor and dynamic management views.
Creating, configuring jobs, linked servers, database mail profiles, alerts.
Database backup, Restoration, migration, attaching and detaching database files.
Creating SSRS reports for various monitoring purpose of the server.
Importing and exporting data to Databases through SSIS
Database Administration Activities - Login / User: Creation/Deletion/Modification.
Performing High Availability solutions for critical databases (Log shipping and Database mirroring)
Basic knowledge of Creation Replication
User login / password creation
SQL Error Log and Windows Event log
Configuring SQL Error Log files.
Mail Configuration.
Scheduling the Job using SQL Server Agent

Database Administrator at Fino Payments Bank

• India - Mumbai
• My current job since March 2017

Email-: amarnath2089@gmail.com.
Mob No-:08291178173, 09892408145

Career Objective
To grow professionally with the company & keep an open mind for learning at any stage.

Total Experience: 4 Year & 10 Months

Company name -: Fino Payment bank Limited.
Infrastructure-: 80 Servers. (More than 65 production servers)
Platform: Microsoft SQL Server 2014, 2008, 2008R2.
Designation-: .Assistance Manager.
Job Roles:
 Installation, up gradation, service packs patching of SQL server.
 Solve problem of troubleshoot.
 Strong knowledge of stored procedures, functions, triggers.
 Creating SSIS and SSRS reports for various monitoring purpose of the server.
 Writing and Optimizing stored procedures, triggers and functions.
 Strong Knowledge on Database mirroring, Replication and Log shippin
Personal Profile:-
 Father’s Name : Ram Dihal Maurya
 Sex : Male
 Date of Birth : 20-07-1989
 Marital Status : Unmarried
 Nationality : Indian
 Language : English, Hindi

DECLARATION:-

I hereby declare that the above written particulars are best of my knowledge and belief.



Date:-
(Amar Nath)

SQL DBA at Fino Payments Bank

• India - Mumbai
• My current job since March 2017

Database Administrator at Angel Broking Pvt. Ltd

• October 2012 to April 2014

Database Administration at New Risk Management System (NRMS)

• India
• September 2012 to April 2014

Title: New Risk Management System (NRMS)
Duration: September 2012 to Till Date
Clients: In-house product
Role: Database Administration
Domain: Risk Management & CTCL Back office system
Development Team Size: 25
Platform: Microsoft SQL Server 2008

Project Description: NRMS is an in-house developed application for Angel Broking PVT LTD for managing Trading Risk Limits, Holdings, Ledger and Balance at all the levels of trading. The Risk is managed at the Brach level, Broker, Sub - Broker and client level.
It's a Risk Management system which is highly configurable and has real-time Broker Limit processing feature

Roles and Responsibilities: • Responsible administration and support of all database environments including development, QA staging, and production.
• Code review and suggest optimization
• Server Health checkups reports and Dashboard.
• Configuring alerts/notifications for Database errors/ States
• Involved in Designing & Implementing Backup Strategy, Index Rebuild/Reorg, and Update Stats.
• Setting up Audit parameters, Data collector and Configuring Resource Governor.
• Performance Tuning proactive as well as reactive
• Installation/Configuration of SQL Servers and Administration activities.
• Implementation of Mirroring
• Coordinating with in-house teams and vendor for Troubleshooting and problem solving of SQL.


Technical Skills

76 Server at Infrastructure

• India
• to

1.7 year

Company name -: Angel Broking Ptv Ltd.