SQL DBA
Resume:
R ESU M E
Pramod Singh
Mob# +91-989******* Email:*****.**********@*****.***
Experience Summa ry
• 4.7 years of IT experience (as a MSSQL DBA).
• Nov 2010 to Feb 2014 with I nfosys Limited, Pune.
• March 2014 – Till Date With L &T InfoTech(ISRC)
• Adequate in I T I L p rocess and I ncident Management .
• Working knowledge in M S SQL Server, I IS,and Cluster Management
• Good knowledge On M icrosoft Azure AlwaysOn Cluster.
Technical Skills
• Operating systems : Windows 2000/NT/8/8.1, UNIX.
• Language : C, C++, C#, .NET Framework 2.0 & 3.0.
• Web Technologies : ASP.NET, ADO.NET, ASP, VBScript, HTML, I IS.
• GUI : V isual Basic, Visual C++, .NET
• Application/Web Servers : I IS Web Server, MS SQL Server 2005/08/12.
• RDBMS : MS SQL 2005/08/12, MS Access, Oracle.
• Tools : M icrosoft Service Enterprise, ITSM, MSRA.
P roject Summa ry
1) Project Name : M icrosoft I T – AIT BI (November 2010 to Feb 2014)
C lient : M icrosoft
Technologies Used : W indows server, M icrosoft SQL Server, I IS, Failover Cluster
M anagement.
C lient : M icrosoft
Role : L ine 2 Support/Incident Coordinator
P roject Description:
M icrosoft MSSALES is the BI centre of excellence handling one of the Microsoft
M ission Critical Financial Applications and reporting tools.
MSSales Production Support Team
MSSALES is most important services line of AIT BI supporting some of the most
C ritical Financial Applications MS Reports, MS Report Analytics and maintains over 30
p roductions and pre-production high availability (HA) of 24x7 servers.
Being a part of this team one gets an ample opportunity to work and learn the
technologies like SSMS, SSAS.
: eLogistics
2) Project Name
Client : Otis Elevators
This application designed and developed on elogistics application which is a supplier chain
management sort of application which covers OTIS elevator sales process.
Elogistics is award winning global level application. Divided into three main modules:
JDE:
OTIS has implemented an ERP solution using JD Edwards OneWorld application
software and running on Windows 2000 Advanced Server and SQL Server 2000
E nterprise Edition. The JDE application provides Enterprise Resource Planning
support for financial and manufacturing systems.
J DE DB routine jobs briefing:
• Regular DB: Sizing report, Security report
• Daily backup log, daily error log checking, performance report checking
• Routine data refresh, DB refresh, task view refresh
• M aintenance jobs, dbcc checkDB, update stats., rebuild \ reorg index,
• Job scheduling, checking, alerting
• Server high serv. alerts, blocking alerts, startup alerts
• C reate SQL login and grant access r ight
• Data Dump request handling
• D B configuration.
• T roubleshooting
Roles & Responsibilities:
Tactical execution of IT I L process on a daily basis, including escalations:
• Regular job maintenance (Batch job/SQL job)
• Managing performance of the IT I L process (per SLAs, metrics, KPIs) within the
i mmediate sphere of control
• Assist with detection of possible Problems and the assignment of them to the
P roblem Management team for them to raise problem records.
• Tracking open incidents and service request records.
• Switching nodes in a failover cluster.
• Providing workaround or Resolving of SQL Issues and SQL Job failures
• Maintaining the application Servers, Databases, Server Logins, Database issues.
• Checking the log utilization for databases and space available for database files
• Performing database backups and restorations
• Configuring and monitoring the Mi r roring
• Proving support for deployments and releases.
• Checking the Failover Cluster Management, Network Load Balancer and I IS
• Rebooting the servers and restarting services as a part of patch installations
• Identifying and reporting the H igh priori ty and Major Incidents to L3 / SME
• Routing incidents to concerned Levels and Teams.
• Detection and notification of possible issues.
• Performing activities to resolve incidents and service requests, or escalating to
escalation management
• Resolving incidents as allowed by the domain knowledge or security access.
• Creating jobs, rebooting the servers, Log shipping, D MV's/DBCC commands
• Overall monitoring of servers and all its services
• Monitoring and creating Service Requests
• Trouble shooting SSMS job failures.
• Maintenance, Troubleshooting, Configuration of SQL and I IS Servers
• Rebooting all the high availabili ty productions and p re-production servers.
• Installation, configuration and upgrading of M icrosoft SQL Server software and
related products.
• Establish and maintain sound backup and recovery policies and procedures.
• Implement and maintain database security (create and maintain users and roles,
assign privileges).
• Database tuning and performance monitoring.
• Controlling access permissions and privileges
• Setup and maintain documentation and standards.
Worked on Functional Escalations from L1 and L2 Team on below issues.
• SQL/Batch job failures.
• Backup/Restore issue.
• Clustering
• Memory management of cubes.
• Transaction log full
• I IS/NLB issues.
• Log shipping, Replication, M i r roring.
1. I have setup the HADR(Alwayson) on Eservice Production and staging taylor
p roject for database servers in Microsoft Azure.
2. Got Hand-on experience on working with M icrosoft Azure starting from creating
t he VM,configuring the AD(Active directory), creating the domains,DNS, vir tual
networks, Affinity Mask, creating endpoints and joining the servers into the
same domain.
3. Implemented the new features in Elog, AMC for deadlocks in SQL 2012 like
extended events and Event notification.
4. Administering Cluster using the PowerShell script like checking the nodes,
resource and event log for cluster nodes.
5. Successfully migrated the Eservice SQL server 2012 to Cloud (Azure) and tuned
database for better performance.
IC Responsibilities:
• Updating knowledge articles with workarounds.
• Handling major incidents and site down issues.
• Coordinating between L1, L2, and L3 team and client management.
• As a shift lead keeping t rack of all issues in the shift. Providing a bridge between
L 1, L2 team and Team management.
E ducation
Q ualification Year of I nstitution University/Boa Aggregate
P assing rd BSC(it) 2010 Birla college Mumbai 68
u niversity
12th 2007 Birla college Maharashtra 65%
Board
SSC 2005 Bhasker H igh Maharashtra 77.48
school Board
Certifications
M ICROSOFT
Credential Description Date Achieved
Microsoft Certified 450: PRO: Designing, 15 Oct, 2011
Technology Specialist Optimizing, and
M aintaining a Database
A dministrative Solution
Using M icrosoft SQL
Server 2008
Microsoft Certified 448: TS: M icrosoft SQL 12 Sep, 2011
Technology Specialist Server 2008 Business
I n telligence–
I mplementation and
M aintenance
11 Aug, 2011
Microsoft Certified 432: TS: M icrosoft SQL
Technology Specialist Server 2008
I mplementation And
maintenance.
Oracle Workshop T raining certification from Oracle
In t roduction to SQL as part of Oracle’s Workforce Development
Completed Oracle database 10g Administration workshop1
Completed Oracle database 10g Administration workshop2
T rainings Attended
• Trained in basics of RDBMS and UN IX at Infosys Technologies L td, Mysore.
• Trained SQL Server 2008 concepts like Database Mi r roring, SQL Server Failover
C lustering.
Personal Details:
Name : Pramod Singh
Father’s name : Suresh
Date of Bir th : 28th A pril 1990
Gender : Male
Mari tal Status : Single
Nationality : Indian
Current Employer : L &T InfoTech
Work Experience : 4.7 years.
Languages Known : English, H indi and Marathi
D EC LARAT IO N:
I hereby declare that the information given above is t rue to the best of my knowledge
and belief.
Date:
Place: P ramod Singh
Contact this candidate