Database Administrator Resume
CAREER OBJECTIVE:
I would like to pursue my career in a work environment that will not only make optimum utilization of my technical skills but also provide me with opportunities that will sharpen my management skills.
PROFESSIONAL SUMMARY:
- Having 4 years of experience as Microsoft SQL Server Database Administrator
- Areas of Technical expertise include Database development and administration using Microsoft SQL Server, SQL Server Integration Services (SSIS) and Application development using C#.Net and ADO.Net
- Excellent analytical and programming skills in using technology to develop effective complex business solutions.
- Good work ethics with excellent communication and interpersonal skills.
- Capable to delve into the new leading Technologies.
- Ability to work well in both a team environment and individual environment.
TECHNICAL EXPERTISE:
Database Technologies: Microsoft SQL Server 2005,2008 R2, 2012, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS)
.Net Technologies: C#.Net, ADO.Net
Markup & Scripting Language: HTML, Java Script, AJAX
Operating System Platforms: Windows 2000/98/XP/ Windows 7
Tools: Microsoft Visual Studio, Microsoft Visual Source Safe, Microsoft SQL Server Management Studio, Microsoft Business Intelligence Development Studio, MES Confidential Fanuc Proficy Plant Application
PROFESSIONAL EXPERIENCE:
Confidential
Database Administrator
Technology: Microsoft SQL Server 2008 R2, SQL Server 2000
Responsibilities:
- Migrated SQL server 2000 to SQL Server 2008 R2 in Microsoft Windows Server 2008 R2 Enterprise Edition.
- Improved the performance of the server by reviewing and modifying the existing code with advanced T - SQL features introduced in SQL Server 2008 R2 such as Data partitioning, Error handling through TRY-CATCH statement, Common Table Expression (CTE).
- Implemented SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
- Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
- Implemented High Availability Solution for the production database using Log Shipping and Alwayson Failover Cluster Instances.
- Converted SQL Server 2000 DTS packages into SQL Server 2005 Integration Services.
Confidential
Database Developer
Technology: Microsoft SQL Server 2008 R2, SQL Server Integration Services (SSIS)Proficy Plant Application V4.1.1
Responsibilities:
- Prepared the Proposal, SRS document, Design document and KPI calculation document for the Project.
- Prepared System integration design document
- Get the project specific infrastructure (software and hardware) installed at the site
- Created Store Procedures, Functions and Views
- SSIS Package to calculate/populate the KPIs data and push it to Oracle server.
- Configured the application based on the accepted and approved design document
- Tested the Confidential Fanuc Proficy Plant Applications 4.2.3 software using production data
- Performed post-implementation support and version tracking of the application in KNOWMAX
Confidential
Application Developer
Technology: SQL Server 2008 R2, SQL Server Integration Services (SSIS) RTIP(Real Time Information Portal), Proficy Plant Application V4.1.1
Responsibilities:
- Developed key solution components in collaboration with P&G team
- Developed the stored procedures, functions, indexes and packages for the application.
- Developed standard documentation of the product
- Application Engineer role for developed solution to support, implement and commercialize this solution globally
Confidential
Technical Executioner
Technology: SQL Server 2008 R2 Proficy Plant Application V4.1.1
Responsibilities:
- Implemented Quality and Schedule View solution in Proficy Plant Application for the production lines.
- Implemented the High Availability Solution for Proficy database using SQL Server AlwaysOn failover cluster instances.
Confidential
Technical Resource
Technology: C# .Net, SQL Server 2008 R2 deviceWISE Workbench, Asset Gateway, Enterprise Gateway
Responsibilities:
- Prepared the Proposal, SRS document, Design document for the Project.
- Prepared System integration design document
- Get the project specific infrastructure (software and hardware) installed at the site
- Configured the Multitech gateway to communicate with ILS M2M cloud services.
- Developed the smart meter portal to consume the JSON web services exposed by ILS M2M management portal.
