Quality Assurance Sql Server
Resume:
Hira Vishwakarma
*********@*****.***
Location : Suwanee , GA
Position Desired: Data Base Services: Remote
Primary Skills
Database Administration, Architecture and Integration, Project Management, Customer Service, BI, CRM, ERP.
Location: US-GA-Atlanta
Status: Permanent Status (Green Card Holder)
Industry Domain: Healthcare, E-Commerce, Media and Engineering.
Revised: Jan -24-2011
EXECUTIVE SUMMARY
Accomplished, innovative and hands on Database Professional with demonstrated experience of over 18 years in planning, developing, and creating robust database architectures and infrastructures development support . My experience include 6 years of Management, 12 years DBA and Development and 3 years of Systems Analysis and 4 years of Data Modeling, 5 years of Business Intelligence\OLAP across SqlServer 2000\2005\2008, ASP.Net, VB.Net and BIDS. Develop and execute 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. Proven ability to identify problems, analyze possible solutions and determine best course of action to meet objectives.
Recruit, train, mentor and lead DBAs from offshore and onshore locations and coordinate efforts on training and engagement efforts on database server cloning, migration, upgrade and disaster recovery efforts. Manage and coordinate with Infrastructure on proactive solutions to minimize impacts on change\ escalation issues.Extremely hands on DBA skills with advanced T*SQL Coding, VB.NET, Business Intelligence, Disaster Recovery covering Logshipping, Replication, Clustering and Performance Improvements using advanced Query Execution Performance, Profiler tools. Lead and organize Infrastructure change management , escalation management and DR Simulation Programs and evaluate Third party softwares\tools and optimize resource utilizations.
Strong Remote working experience using Webex, Home Office and Conference Calls. Use Unisys Service Tickets Peregrene and Symantec Service Desk.
Strong Leadership and Management experience, interaction with Senior Management teams, Director Level meetings on Enterprise Database level support. Provide thought leadership on managing resources, upgrades, third party tools, Global Database Architecture and Administration support.
Reports to: Director Enterprise Database Services.
TECHNO FUNCTIONAL ROLE:
Conceptualize , architect , structure and implement best practices on coding, debugging, deployment , and proactive monitoring of database servers on Microsoft platforms such as Sqlserver 2000, 2005 and 2008, Oracle 8.x, 10 g and E-Business Suite, MySql 4.x and 5.x . Resolve, implement Robust database solutions on disaster recovery and business continuity such as Replication, Mirroring and LogShipping and Microsoft Clustering. Implement TCP\IP Connectivity, ODBC \OLE Standards. Author and Implement Database standards on naming convention, deployments and performance..
Implement solutions for optimizing database schema, SQL queries, and installation routines. Lead efforts on creating utilities for operational teams and development team usage on coding, code reviews, code deployments ,code migrations and maintenance schedules. Work with leadership on defining Service Level Agreements (SLA) for availability and integrity of databases and applications.
PROJECT MANAGEMENT ROLE:
Provide thought leaderships on Infrastructure planning, hardware specification, and platform migrations. Supervise and resolve Unisys based Peregrene and Altiris tickets on Database, CRM, DataWare Housing and Application issues on a timely basis.. Creating trends of open \closed tickets for meeting SLAs and provide inputs to management on status. Plan, focus and track project schedules and present deliverables. Meet expectations and lead teams to adhere guidelines on standards and technical excellence. Provide feedback and training to staff and motivate for performance and consistency.
LEADERSHIP ROLE:
Leading and mentoring company's DBAs, Analysts and Software Developers on SqlServer, Mysql and Oracle, Microsoft Dynamics, Epicor Clientele CRM environments and lead them to be highly productive, motivated and enriched to be capable of tackling problems, diagnose code bugs, proactive maintenance and continuing improvements. Managing operational production database environments and overseeing daily operations including planning for migrations, monitoring, tuning, upgrades and disaster recovery.
Review the design and architecture of database systems, capacity planning, performance metrices, and design database partitioning. Lead DBA efforts on moving servers from physical to VM Ware environments and implement global backups and restore solutions on Netapps..
CHANGE MANAGEMENT ROLE:
Provide leadership on Change Management Formats, documenting procedures for change and implement change management processes. Work with IT Infrastructure teams to plan, implement and resolve Change Management tickets on pre defined, escalated and approved measures. Notification of Change management issues with global distribution lists and resolve any escalations issues on post implementation of Change management. Lead efforts on documenting in E-room storage all incidents in timely and effective manner. Keep leadership communicated on critical local and global issues on any maintenance windows, unavailability of systems and applications, and connectivity and downtime issues.
CROSS FUNCTIONAL ROLE:
Facilitate integration of database design, application design and infrastructure into a scalable framework. Monitor data management and data architecture technology advancements and industry best practices. Implement Database standards, performance standards and benchmarks on execution standards. Work with DBA's, Business Analysts, Architects and Developers to standardize processes and tools.
CONSULTING ROLE:
Advising senior leadership on technology and industry direction and strategies and lay down vision for database growth, upgrades, integration and application usage with changing business focus. Document detailing the existing data infrastructure, design standards for future development. Managing projects to accomplish the objectives as well as to address company’s evolving database management needs including overseeing technology budgeting, software purchases, third party monitoring tools , licensing requirements and compliance, interaction with vendors on software procurements and installations and addressing post purchase support systems.
AREAS OF EXPERTISE
• Management Database Design, Architecture and Administration, Strategic Analysis Architecture and Integration.
• Organization and Staff Development Budgeting and Cost Control
• Team Development Building and Peer support.
• Infrastructure Support and Software Licensing.
• Hardware architecture, specification and Stress Testing.
• Project Management , Customer Service, Business Analysis and Customer Relations Management.
PROFESSIONAL EXPERIENCE
Company:
Iworld Wide Ventures ,LLC ,GA
Client: Impact Medical
Position : Enterprise Database Administrator : July 2008-Present
Reporting to the Director, Enterprise Systems, 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 Operations spanning over managing over 10 SqlServer 2000, 60 SqlServers 2005 and 50 Servers on SqlServer 2008. An accomplished performer on integrating database technologies across CRM , Clientele CRM , Microsoft Dynamics, Sharepoint , Variscent and Laboratory Information Management Systems.
• Manage both on-site and off-site development teams, network administrators, business analysts, developers and quality assurance teams. Significantly reduced downtime of all e-commerce platforms by implementing best practices for software patches and relocations.
• 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 For Compressing Data and Log Files, Back Up Level.Migrating Databases from Sql server 2005 to Sql server 2008.Installed SQL Server 2008 Failover cluster.
• Implemented and setup database mirroring and replication as a part of disaster recovery solution.
• Worked with the table partitioning (Sql Server 2008) mechanism to allow the SQL Server engine to escalate locks to the partition level before the table level.Worked with Transparent Encryption, table compression, database compression and merge statements using Sql server 2008.
• Used Policy Based Administration feature (Sql Server 2008).
• Expertise in using Temporary Tables, Table Variables, and CTEs. Monitoring the event logs and Server error logs using DBCC utilities for troubleshooting purposes .Expertise in Database Backup and Recovery procedures for Disaster recovery.Good experience with logical modeling and physical modeling by using ERwin.Expertise in Performance Tuning, Query Optimization, Client/Server Connectivity, Database consistency checks using DBCC 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 Performing database consistency checks using DBCC Utilities and handling data corruption in user databases.
• Expertise in Identifying the bottlenecks caused by complex queries using Activity Monitor/SQL Profiler and handling them by implementing better Query Execution plans.Verified the Stored procedures created by developers and fine 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.
• Monitored the database activity to identify and resolve the performance issues using SQL Server Profiler.Expertise in writing and debugging stored procedures ,triggers, Optimizing Code and Improving Efficiency in databases including Re-indexing, Updating Statistics, Recompiling Stored Procedures and performing other maintenance tasks.
• 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.
• Experience in working with SharePoint both in MOSS and WSS.
• Created Table Valued Parameters (Sql Server 2008) of a table value data type and be able to pass this variable into a stored procedure.Rendered Reports to Microsoft Word using Sql Server 2008.
• Created new database objects like Tables, Procedures, Functions, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2005.Data loading into Tables using SSIS Packages.
• Data Extracting from Different online Forms and Integration Data to Load into the Tables.Involved In Database Design, Normalization, Indexing.Maintaining the database consistency with DBCC, DMV and DMF’s at regular intervals.Implemented new T-SQL features added in SQL Server 2005 that are Data partitioning, Error handling through Try-Catch, Common Table Expression (CTE), Ranking Functions. Designed and Developed Various Reports Like Adhoc, Matrix and Tabular Using SSRS.
• Using Visual Studio Editor and Report Viewer Controls Created Rdlc Files for WebPages.
• Documented database design and developed a data dictionary for corporate database.
• Identified and resolved database performance issues, database capacity issues and other distributed data issues.
• Maintaining SQL Script for creation of Database Objects using SVN, Mantis for Production Tickets.
• Analyzing long running slow queries and tune the same to optimize application and system performance.
• 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. Introduced the benefits of Open Source e-Commerce solutions to increase presence on the Internet.
• 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.Led successful implementation of numerous projects to help increase traffic and conversion, product normalization, expert and customer reviews.Enabled web services to expose data to affiliates and widgets to increase web exposure.
• Manage both on-site and off-site development teams, network administrators, business analysts, developers and quality assurance teams. Significantly reduced downtime of all e-commerce platforms by implementing best practices for software patches and relocations. 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.
• Led successful implementation of numerous projects to help increase traffic and conversion: multiple page designs, product normalization. Enabled web services to expose data to affiliates and widgets to increase web exposure.
Career Builder LLC , Norcross ,GA
(World-leading Career portal Site that houses one of the largest Data Ware House Systems)
Position :Principal Database Engineer : Dec 2006-June 2008
Reporting to the Director Operations , 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. Manage and mentor a team of twenty professionals.
Supervised Offshore DBAs and Developers at India center on augmenting staff’s capabilities, 24\7 support and productivity. Lead onshore DBAs and business analysts on data analysis and database operational support on meeting company’s laid down SLAs.
• Manage Tech Support, Software Development, Quality Assurance, Network Administration, and Data Processing.
• Improve service levels. Establish a rapport and credibility with department heads and directors.
• Introduce and integrate new technologies and explore new tools like Idera, Confio, SqlSentry, Sitescope .
• Internet and Intranet sites for employees and customers helping increase revenue.
• Hire and manage staff of differing cultures and unite into cohesive teams.
• Develop in-house quality assurance Systems that enabled well-timed competent customer applications.
Innovation Interactive Inc , NY
(A Premier Advertizing Company specializing in search engine traffic and online media conglomerate, based at New York and Atlanta )
Position :Database Manager : Feb 2002-November 2006
Mentor and supervise 1 DBA, 1 Developer.
Reporting to Technical Director :
Principal consultant on database technology to the CEO and board of directors.
• Contributed to the definition of key strategic objectives leveraging new initiatives on company’s search engine capability.
• Document, implement, and set accountabilities for software development and quality assurance.
• Manage all aspects of the Software Development Life-cycle and product development team.
• Increased productivity through application development and deployment.
• Develop, test, and execute best practices for security implementation of database systems and database recovery.
• Implement solutions leading to disaster recovery and business continuity practices.
Reengineered a number of financial, sales, and operations departments systems using Sales Force Software and implemented a robust database management systems for Rawhide Search Solutions . Lead DBA and Developers team and helped them to aid productivity and integrity of database technologies in the company.
Advanced Technical Staffing , PA
A premier consulting company specializing in Technical and Software Development )
Position :Senior Database Administrator : Jan 2001-Jan 2002
Reporting to Program Manager :
Provide guidance as a lead of the Data Management Department. 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. Completed projects ahead of schedule, resulting in substantial savings in the budget.
• Design, code, test complex objects, triggers, and stored procedures.
• Participate in definition/implementation of client/server architecture and referential integrity.
• Documentation and automation of day-to-day DBA tasks/processes.
• Delegate, help and mentor Junior Database Administrators. Monitor back-ups, error log and associated tasks.
• Resolve various problems associated with back-end such as contention, locking and replication.
Reliance Systems Inc ,AZ
Senior Support Specialist, 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. Support over 35 clients with their software application, including but not limited to troubleshooting hardware and software problems.
Solve UNIX issues concerning scripts, interfaces, checking ports, permissions, and other issues.
Closed over 1200 support cases. The highest amount in support center, during that time period.
Provide support for technicians on site. Supervise support specialist on second shift.
Oil and Natural Gas Corporation ,India
Senior Systems Engineer: May 1994-April 2000
Successfully supervise and administer the day-to-day operations of a corporate giant engaged in Exploration of oil and natural gas, increasing sales, quality and exceptional service.
Accountable for budgeting, cost control and full profit and loss.
Investigated and resolved issues on quality and service complaints, ensuing customer satisfaction.
Recruited, hired, managed, scheduled and motivated a staff of approximately 15 employees.
trained service staff to enhance customer satisfaction and remain technologically informed.
Implemented tight inventory controls and cost saving measures resulting in a 15% decrease in data processing costs.
EDUCATION
Executive MBA – Decision Support Systems :INDIA
Master of Science : INDIA
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,
Ticketing \Service Desk:
Unisys’s Peregrene, Altiris, Symantec: Service Desk.
Miscellaneous:
Microsoft Team Foundation, Microsoft Sharepoint, Exchange, SCADA,
Tools:
SQL DB Access, Performance Monitor, ERwin, MS Visio, RedGate, MS Office 2000/2003/2007, MS Outlook 2000/2003/2007.
Backup and Monitoring Tools: Idera: Diagnostic Manager, Litespeed, Veritas Net Backup, Spotlight
Contact this candidate