Microsoft Certified IT Professional
(MCSA) 70-462
Professional Profile
Out of 14+ years IT Experience, 7+ years of experience in Core SQL Database Administration with strong Banking Domain and administration and implementation experience using SQL Server 2014/2012/2008R2/2008/2005. Seeking a challenging career and growth-oriented position in Microsoft SQL server database administrator Environment where knowledge can be shared & enriched logically.
Technical Highlights
§
Over
7+ years of experience in Database
Administration of MS SQL Server 2016/2014/2012/2008R2/2008/2005 in Production,
Test, Development and Cluster Environment.
§
Expertise
in Database Administration on Production Servers with Server configuration,
Performance Tuning and maintenance with outstanding troubleshooting
capabilities.
§
Expert
in Implementing High Availability solutions like DBMirroring, Log shipping and Always
ON.
§
Experienced
in Upgrading the SQLSERVER 2008 to SQL SERVER 2008R2 and from sql2012 to sql2014.
§
Experience
in Installation, configuration, maintenance, monitoring and troubleshooting.
§ Managed database users and security by
granting/revoking appropriate permissions to logins/groups and migrating logins
and troubleshooting Orphaned Users.
§
Experience
in patching activities on SQL Server
(2005, 2008, R2, 2012, 2014).
§ Managed database
users and security by granting/revoking appropriate permissions to
logins/groups and migrating logins and troubleshooting Orphaned Users.
§ Expert in configuring and troubleshooting Always On Availability Groups and good
implementation knowledge on configuring backups on AG database.
§
Migration
of databases between the servers.
§ Having
experience in using 3rd party Backup tools–NetBackup,
Tivoli
§ Having
experience in using ticketing tools like Remedy, ITSM, Service snow
§ Expert
in implementing Recovery Models, Backup
and Restore.
§
Experience
in index maintenance and Maintenance
plans.
§
Performing database maintenance activates like Re-indexing, DBCC CHECKDB and Update Statistics to increase/maintain
db performance.
§
Having
experience in creating Linked server to SQL Server and Oracle database servers.
§ Configuring, Scheduling and routine Jobs, Tasks,
Alerts and Maintenance Plans.
§ Creating and Troubleshooting job failure.
§ Resolving Disk
space alerts.
§ Experience in Performance Tuning, index maintenance
and table scan etc.,
§ Using DBCC commands for maintaining the database consistency.
§ Maintaining the database consistency with DBCC
commands (CHECKDB, SHOWCONTIG, SHRINKDB, INDEXDFRAG etc…) at regular intervals
§
Configuring,
Scheduling and routine Jobs, Tasks, Alerts and Maintenance Plans.
§ Migrated data from various sources such as MS Access,
flat files etc.
§
Good
Understanding of SQL Server clustering and Keen interested to work on
clustering.
§ Good working knowledge on Incident Management, Problem Management and Change
Management.
Application implementation
- Detecting
and fixing the bugs that are found during implementation.
- End
user training after implementation.
·
Leading the team to keep track of production
support activities.
·
Tracking/managing issues from initiation to
successful completion.
·
Resolving Implementation issues, problems,
and changes.
·
Managing the customer expectations.
·
Involved
in full life cycle development of core banking solution. Handled testing,
debugging and troubleshooting of the application.
·
Co-ordinate
for smooth implementation of the project at client location. Extended
Post-implementation, Application maintenance and Technical support to the
client.
·
Worked
with reputed clients like RDCC Bank, Vijaya
Bank and SBH.
IT Skill Sets
OS : Windows XP / NT / 2000 / 2003 / 2008
/ 2012
Cloud platform
: Microsoft Azure
Languages : SQL, T-SQL
Databases : MS SQL Server 7.0/2000/2005/2008/2012/2014/2016
SQL Server Tools : Management Studio, Enterprise Manager,
Query Analyser, Profiler,
Performance
Monitor, OSQL, DTS, Log Shipping, Database Tuning
Wizard, Index
Tuning Wizard
Data Migration :
Import/Export Wizard, DMA (Data Migration Assistant)
Tools &Utilities :
MS Office. PowerShell
Third Party Tools :
NetBackup, Tivoli
Ticketing Tools
: Remedy, ITSM, Service snow
Achievements
§ Successfully
deployed total branch automation software
(BancMate) at Vijaya Bank, RDCC Bank Raichur, by effective co-ordination
and efficient client interaction.
§
Successfully implemented BMFI software for
SBHFI and done successful testing and create live environment for FI
transactions first time in HCL Infosystems.
Education Details
PG
from Andhra University (M Com)
Training Programs
§ DNIIT Certification from
National Institute of Information Technology (OCT 2000-OCT 2003).
PROFESSIONAL EXPERIENCE
Project #0 Smartek21., Aug’2016 – Till Date
Since 2006 provides
outcome-based deliverables by combining project-driven professional services
and ongoing managed services that help identify, deploy, optimize and support
the right technology and applications to deliver on your specific business
goals.
Client :
Liberty Mutual Insurance.
Role : Sr Software Engineer.
Platform : Database
Server (MS SQL Server 2005, 2008, 2012, 2014/2016)
Project #1 HCL
Technologies Pvt Ltd., Sep’2015 – Jul’2016
Novartis International
AG is a Swiss multinational pharmaceutical company based in Basel, Switzerland,
ranking number two in sales (46.806 billion US$) among the world-wide industry
in 2010. Novartis is the only company with leading positions in each of these
key areas like Pharmaceuticals, Alcon, Sandoz, Consumer Health, Vaccines and
Diagnostics.
Client :
Novartis.
Role : Sr Specialist.
Platform : Database
Server (MS SQL Server 2005, 2008, 2012, 2014)
Project #2 Tech
Mahindra
Dec’2013 – Sep’2015
Implementation
and support of Shared Vertex
Founded in 1978,
vertex is the trusted leader in corporate tax technology excellence.
Global headquarters
is in USA, European Headquarters is in UK.
Vertex is
tax application which is lead application in the market.
Client :
Microsoft.
Role :
Sr DBA.
Platform : Database Server (MS
SQL Server 2012, 2014.)
Project #3 HCL Infosystems
Ltd.,
July’2010 – May’2013
Implementation
and support of FINANCIAL INCLUSION Server
Financial
Inclusion enables access to affordable banking services - such as savings
credit, remittance, insurance and pension by the vast majority of the population
in the rural areas and an organised sector at their door step and as per their
convenience. It provides all features of banking industry.
Client : State Bank of Hyderabad.
Role : Lead Implementation
Engineer.
Platform : Web Server (Linux), Database
Server (MS SQL Server 2008.)
Project #4 Implementation
of BancMate
May’2008 – June’2010
BancMate is banking
software that facilitates total branch automation. The project includes
implementation, post migration support, user training and maintenance. Broadly,
my role involves identifying the new strategic plan to accommodate future
growth and creating a road map for maintaining current performance while
developing a new vision over multiple phases.
Client :
RDCC Bank.
Role : Lead Implementation
Engineer.
Platform : Power Builder, MS SQL
Server 2005.
Project #5 Natural
Support Consultancy Pvt. Ltd, Jaipur Head Office. July’06–Apr’08
- Worked
as an Implementation Engineer.
Client :
Vijaya Bank.
Role : Implementation
Engineer.
Platform : Power Builder, MS SQL
Server 2005.
Non IT Work Experience
Natural Technologies Pvt.Ltd., Sep’04–Jun’06
- Worked
as a consultant support.
BSSI (NIIT@School Project) Oct’02–Aug’04
Worked as
coordinator with BSSI, handling a team of 20 members.
St.Peter's
Jun’96–Sep’02
Worked as a Teacher
in St.Peter's School