Sql Server Manager
Resume:
Hira Vishwakarma
*********@*****.***
Location : Atlanta, GA
Work Status: Permanent Status (Green Card Holder)
Domain Skills: Healthcare, E-Commerce, Media and Engineering. Database
Administration, Development, Architecture and Integration, Project
Management, Customer Service, BI, CRM, ERP,Neatpp Storage. VMWare, SAN
Storage, NetApp. .
Position Desired: Database Developer\DBA : Remote
EXECUTIVE SUMMARY
Accomplished, innovative and hands on Database Professional with
demonstrated experience of over 12 years in developing and administering
robust database architectures and supported infrastructure development.
My experience include 10 years of database administration and
development across SqlServer 2000\2005\2008R2\2012, ASP.Net, C#, VB.Net
and BIDS. Develop and implement strategic plans for implementation of
policy, tools, standards and process designed to maintain compliance with
corporate and external database requirements, operational excellence
through lifecycle management, database standards, good security
practices, focusing on managing database performance standards,
minimizing implementation risks and users training.
Strong self managed remote working experience, timely resolution of
escalations, change control and adhere to strict timelines and
development schedules.. Very focused on customer requirements,
satisfaction and lead efforts on database management upgrade, migration,
disaster recovery, Business Continuity and performance improvements.
Follow agile lean management style to resolve issues in timely manner.
Worked with help desk tickets, such as BMC Remedy, Peregrene, Symantec to
document procedures, processes and solutions. Strong Remote working
experience using Webex, Conference Calls..
EDUCATION
Executive MBA - Decision Support Systems
Master of Science Computer Applications
TECHNICAL SKILLS AND PROFICIENCIES
Databases:Microsoft Access, SQL Express, MSDE, MySQL, SQL Server
2000/2005/2008 R2 (Merge/Transaction/Snapshot replication,
Logical/Physical Data Modeling, Stored Procedures and other T-SQL code,
Installation, upgrading and maintenance of clustered and stand alone
environments, Log Shipping and Database Mirroring)
Programming:Visual Basic, VB.NET, ASP.NET, .ColdFusion, PHP, T*SQL,
PL\SQL, C#.
Operating Systems:Windows XP, Vista, Windows 2003, Windows 2003 R2,
Linux. VM ESX.
Network Technologies:Active Directory, Group Policies, DNS, DHCP, VPN,
RAS, LAN/WAN configuration, router and switch configurations, SANs and
NAS, Netapps.
Systems: Client Server Technologies, Business Intelligence, Data Ware
Housing, Customer Relations Management, Reporting Services, Operational
Data Store. VM Ware, Sql Diagnostic Manager, Confio, Sql Sentry Manager,
Log Shipping, DMVs, Database Mirroring.
CRM:Microsoft Dynamic CRM, Microsoft Dynamic Great Plains,,
Virtualization Technologies. EPICOR'S Clientelete CRM, Sales Force.
Ticketing \Service Desk:Unisys's Peregrene, Altiris, Symantec: Service
Desk.
Version Control: VSS, Team Foundation.
Miscellaneous: Microsoft Sharepoint, Exchange, SCADA, GPS, Great Plain.
Tools:ERwin, MS Visio, MS Office 2000/2003/2007, MS Outlook
2000/2003/2007.
Monitoring Tools: Idera- Diagnostic Manager, Spotlight, Confio, Snap
Manager
Backup Tools: LiteSpeed, Redgate, Snap Manager, Veritas Net Backup
PROFESSIONAL EXPERIENCE
Company:I World Wide Ventures,GA
Client: Impact Medical Systems, GA
Database Developer\Administrator : July 2008-Present
Responsible and accountable for ensuring that the company's enterprise
infrastructure is highly available, extremely scalable while maintaining
great performance levels. Leading the efforts for design, implementation,
maintenance, and support of the system architecture for the entire e-
Commerce, ERP, CRM, Sharepoint and Microsoft platform while continuing
to be a top performer on Enterprise Architecture
Technical Value Addition:
. Installed and Upgraded from Sql Server 2005 to Sql server 2008 and
2008R2 on Various Production Servers. Implemented Sql Data
Compression Using Sql server 2008.
. Develop Stored Procedures, User Defined Functions, Table valued
Function, Common Table Expression, Sub Queries, Merge Statements,
Execute Estimated Query Execution plan to identify table and Index
Scan. Optimize queries for best performance ensuring query
processor uses Index Seeks. Optimize indexes and update statistics.
. Work with Developer to use self joins, outer joins and optimize
query results for performance. Code reviews and Tune top Sql
queries.
. Plan, participate and execute Production Roll Outs from QA instance
and participate in SqlServer upgrades and service pack fixes. Used
VSS and Team Foundation for Version Control. Used Service Desk for
Change Control and Escalation issues.
. Designed Partition Functions and Partition Scheme for range data
values for performance improvements.
. Develop SSRS reports, enhancements and deployments in Report
Manager. Configure Report Builder and set up SSRS Security.
. Develop SSIS Packages, work on data flow, control flow, precedence,
containers and Event handling. Design ETL data sources, data
source views for performance. Used connection manager such as
ADO.NET, FTP, ODBC, SMTP. Created container for Loop.
. Setup database logshipping, mirroring and replication as a part of
disaster recovery solution. Set up Transaction Replication,
configure publisher,distributor agents, subscribers and monitor
database synch and resolve issues pertaining to transactional
replication.
. Implement Database disaster recovery solutions such as Log
Shipping, Database Mirroring Synchronous and Asynchronous. Created
Encryption using creating master certificate.
. Worked with Locks, blocks and deadlock situation and resolved
issues in QA and Prod Environments.
. Configured Filestream Database connection to store images data ..
. Implemented sound backup strategy of databases with full,
differential and transactional backups. . Use low level DB
Compression.
. Worked with Transparent Encryption, table compression, database
compression and merge statements using Sql server 2008. Used Policy
Based Administration feature of Sql Server 2008.
. Develop Stored Procedures, Triggers, User Defined Functions,
Develop SSIS Packages for ETL processing, Use fast load and fuzzy
logic and XML Components.
. Monitoring the event logs and Server error logs using DBCC
utilities for troubleshooting purposes.Performance Tuning, Query
Optimization, Client/Server Connectivity, Database consistency
checks using DBCC DMVs Utilities .
. Expertise in using Performance Monitor/Profiler to resolve Dead
Locks/Long running queries on 32 bit and 64 bit clustered and
standalone server environments.
. Expertise in Identifying the bottlenecks caused by complex queries
using Activity Monitor/SQL Profiler and handling them by
implementing better Query Execution plans. Developed Stored
procedures and tuned the scripts for better performance using
Database tuning advisor.
. Optimized Indexes for better performance using SQL Query Plans at
Query Analyzer and Index Tuning wizards. Used DBCC Checks, Update
Statistics and Dynamic Management Views, Wait Stats.
. Experience in Software Development Life Cycle (SDLC), Analyzing and
Designing systems using Structured Methodologies (ERD, DFD) along
with extensive knowledge of Relational Database Management Systems
with in-depth of T-SQL. Experience in Batch processes, SSIS, DTS,
BCP, Import, Export, and Backup.
. Extensively implemented the change management processes by using
team foundation server (TFS), Visual Source Safe (VSS) and Clear
case.
. OLAP experience using Analysis Services (SSAS), Reporting Services
(SSRS) and Integration Services (SSIS) to manage data ware house
environment. Create Feeds using C# in Sql Server Databases.
. Installed, configured and implement Sql Server Reporting Services.
Developed and created stored procedures, developed RDLs, deployed
and implemented SSRS Security. Managed Report Manager URL and
report Builder. Designed and Developed Various Reports Like Adhoc,
Matrix and Tabular Using SSRS.
. Deep understanding of RAID, NETAPP and SAN architecture. Set up
mount point architecture for Snap Manager and DR Recovery and quick
database restores.
Company Value Addition:
. Good team player, strong interpersonal and communication skills
combined with self-motivation, initiative and the ability to
multitask. Increased monitoring of all single points of failure and
reduced downtime by upgrading the infrastructure
. Reduced hardware costs by using virtualization technologies to
minimize downtime for critical systems. Implement VM Ware
architecture on 70% of existing database servers and moving the
databases. Create scripts using C#, Powershell and Perl Scripts.
Implemented Snap Manager for Sql Backup solution and mount Point
Architecture for Disaster Recovery.
Environment: Microsoft SQL Server 2005 SqlServer 2008\2008R2\Sql2012, 64
bit, Windows 2008 R2, ASP, Redgate Sql Bundle, Visual Source Safe,
Microsoft Clustering, Performon tools, ERWIN, Business Intelligence
Development Studio, Analysis Services, Reporting Services, SSIS,SSRS,
Transaction Replication, EPICOR Clientele CRM, Microsoft GP Dynamics 10.
MSCRM, WMWare,BizTalk,Sharepoint,XML,ESXServer,Idera Diagnostic Manager,
Netapp, C#, PowerShell, MySql 4.x,5.1 Versions., MOSS 2007, VMWare. Quest
Software Backup tool, ProIT.
Company :Career Builder LLC, Norcross,GA
Database Developer \Administrator : Dec 2006-June 2008
Responsible for managing all aspects of the company's Database Servers.
Oversee major IT functions including: security risk assessment, incident
response, security policy creation and enforcement, business continuity
planning, disaster recovery, project management, budgeting, application
support, and business planning.
Technical Value Addition:
. Installed Sql Server 2005 and configured instances for best
performance.
. Develop Stored Procedures, Triggers, T*Sql, User Defined Functions,
Develop SSIS Packages.
. Monitoring the event logs and Server error logs using DBCC
utilities for troubleshooting purposes
. Performance Sql Server Tuning, Query Optimization, using Estimated
Execution Plans.
. Implementing best maintenance and database optimization practices,
integrity checks and database backups and restores.
. Index design and index optimization and rebuild versus reorganize.
Update Statistics of tables after DML operations.
. Managing data dictionary and archive old data for reporting.
Migrating DTS to SSIS.
. Implement partition function and partition schemes, Implement best
maintenance practices using DBCC Commands and best practices
analyzer.
. Implement best practices on Index tuning and update statistics and
database sizing.
. Implemented DMV scripts for CPU, Memory and Disk IO,
blocking\locking information.
. Created scripts for tempdb sizing, growth and monitoring and used
DBCC shrinking (of databases and files) for containing log files
within acceptable limits.
. Used xp_cmdshell for scripting and operating system file management
with Sql Server.
. Expertise in using Performance Monitor/Profiler to resolve Dead
Locks/Long running queries .
. Expertise in Identifying the bottlenecks caused by complex queries
using Activity Monitor/SQL Profiler and handling them by
implementing better Query Execution plans. Developed Stored
procedures and tuned the scripts for better performance using
Database tuning advisor.
. Optimized Indexes for better performance using SQL Query Plans at
Query Analyzer and Index Tuning wizards. Used DBCC Checks, Update
Statistics and Dynamic Management Views, Wait Stats.
. Extensively implemented the change management processes by using
Visual source safe (VSS).
. OLAP experience using Analysis Services (SSAS), Reporting Services
(SSRS) and Integration Services (SSIS) to manage data ware house
environment.
. Introduce and integrate new technologies and explore new tools like
Idera, Confio, SqlSentry, SiteScope .
Company Value Addition:
. Strong team player, self-motivation, initiative and the ability to
multitask. Learnt Lean style of Project management by using Agile
methods.
. Improved performance of Top 20 queries in ETL by 40 % by using best
database maintenance practices and consistent monitoring of
instances..
Environment: Microsoft SQL Server 2005,,My Sql 4.x, Windows 2003 Server
on 64 Bit, ASP, Veritas Backup, Sql Safe, LiteSpeed backup, VB.Net,
ODBC, Data Transformation Services, Visual Source Safe, Microsoft
Clustering, Performon tools, ERWIN, Business Intelligence Development
Studio, SSAS, SSRS, SSIS, XML,Lawson, OutlookSoft, Idera 's tools: Sql
Safe backups and Sql Diagnostic Manager, Sql Sentry,
Innovation Interactive Inc, NY
(An Online E-Commerce Media Company based at New York )
Position :Database Administrator : Feb 2002-November 2006
Identification of key strategic objectives on Database Design and
leveraging new initiatives on company's search engine capability.
Document, implement, and set accountabilities for software development
and quality assurance pertaining to database development and
administration.
Technical Value Addition:
. Installed MS SQL Server 2000 and developed DTS Packages. Scheduled
Index optimization and DBCC checks of databases and tables and
automated Sql Server maintenance jobs.
. Migrated database from Oracle to Sql Server 2000. Installed SQL
Server 2000 on Windows 2000 Servers.
. Implemented SQL Logins, Roles and Authentication Modes as a part of
Security Policies for various categories of users Performed
Administration, upgrade and database Programming architectural
design.
. Developed T-SQL stored procedures, functions and Views. Designed
and implemented comprehensive Backup plan and disaster recovery
strategies. Created documentation on database naming conventions,
capacity plans, server performance metrics, database optimization
plans, maintenance plans and performance tuning measures.
. Tuned SQL queries and Stored procedures using SQL Profiler and
Index Tuning Wizard.
. Used system stored procedures and DBCC commands. Scheduled jobs and
alerts using SQL Server Agent Service. Implemented Transaction
Replication with 2-phase commit for Reporting purposes.
Company Value Addition:
. Strong team player, motivation, initiative and the ability to
interact with several teams.
. Improved performance of Search Engine by 30 % by using best
database maintenance practices.
Environment: Microsoft SQL Server 2000, WIN 2000, Veritas Exec
Software, ODBC, DAO,ADO. ASP, Veritas Backup, Sql Safe, LiteSpeed backup,
ODBC, Data Transformation Services, Visual Source Safe, Microsoft
Clustering, Performon tools..
Advanced Technical Staffing, PA
(A Consulting Company specializing in Technical and Software Development
)
Position : Database Administrator : Jan 2001-Jan 2002
Perform logical and physical database design, administer existing
databases, data analysis, object analysis, batch, and T-SQL scripting,
backup and recovery, troubleshooting. Perform database configuration
management, sizing and tuning.
Technical Value Addition:
. Design, code, test complex objects, triggers, and stored
procedures.
. Participate in definition/implementation of client/server
architecture and referential integrity.
. Implement Backup and database restore policies.
. Implement Transaction Replication.
. Documentation and automation of day-to-day DBA tasks/processes.
. Delegate, help and mentor Junior Database Administrators. Monitor
backups, error log and associated tasks.
. Resolve Lock Escalation, contention and replication issues.
Company Value Addition:
. Strong team player, motivation, initiative and the ability to
interact with several teams.
. Improved performance of SCADA Engine by 50 % by Reindexing tables.
Environment: Microsoft SQL Server 2000, WIN 2000, Veritas Exec
Software, ODBC, SCADA, Veritas Backup, ERWIN.
Reliance Systems Inc,AZ
Technical Support Analyst: May 2000-Dec 2000
Troubleshoot interpret problems and provide superior technical support
for clients relating to hardware, software, and systems. Answer telephone
calls; analyze problems using automated diagnostic programs, and resolve
recurrent difficulties.
Technical Value Addition:
. Develop database diagram, flow chart and data models.Create
databases, configure and create objects such as tables, views,
triggers, and stored procedures.Participate in
definition/implementation of client/server architecture and
referential integrity.
. Implement Backup and database restore policies. Restore databases
from Tape on Demand.Documentation of Database Architecture, Data
Flow Diagrams.
. Monitor backups, error log and sql server error logs, Windows Event
Logs.Resolve Lock Escalation, contention and replication issues
Company Value Addition:
. Good team player, motivation, initiative and the ability to
interact with technical teams.
. Improved performance of client 's systems by 40 % upgrading
SqlServer and Service Packs.
Environment: Microsoft SQL Server 7.0/2000,Oracle 7.3, WIN NT 4/2000,
PeopleSoft, Veritas Exec Software.
Contact this candidate