Senior MS SQL Server DBA with 6+ years of IT experience in Database Administration, Design, Development, Installing and Support of MS SQL Server 2014/2012/2008/R2/2005/2000/7.0 in Production, Testing and Development Environment’s.
Experience in Data Migration from MS SQL server 2000/2005 to 2005/2008/R2/2012.
Experience administering Oracle 10G environment
Sound experience in Visual Studio 2010, with writing application in ASP.NET, C# and MS Access
Extensive Monitoring of SQL Server with DMVs and Third Party Tools like IDERA, FOGLIGHT, QUEST
Implemented Backup and Restore in SQL Server using Native SQL Backups and also using Third party tools like VERITAS NetBackup, Red Gate, TSM and LITESPEED.
Expert skills in VMware and Virtual environments
Expert skills in setting up CLONE process using RM (replication manager), SQL job and PowerShell scripts.
Experience in Performance Tuning, Query Optimization, Database Consistency Checks using DBCC Utilities and Linked Servers.
Experience in using different Transformation tools like DTS Packages, SSIS and also, BCP and BULK INSERT.
Experience in using different tools like DELPHIX to manage virtual database, APEX SQL for auditing and monitoring, BMC for multiple installation and patches at once, Attunity for replication, Netezza for data warehouse and reporting purpose.
Experience in implementing different types of Replication topologies involving Snapshot, Merge, Transactional and updatable.
Has good knowledge in implementing Log Shipping, Data Mirroring Techniques.
Knowledge in Installing and configuring Cluster SQL Servers in Active/Passive and Active/Active environments.
Experience in developing and supporting all stages of systems life cycle including Analysis, Development, Testing, Implementation and Product Support using T-SQL, PL/SQL on Unix and Windows environment
Moderate experience with T-SQL in developing Database Objects, Triggers, stored procedures, Functions.
Developed Oracle based (SQL and PL/SQL) programs for the creation of ad hoc queries/reports, including requirements gathering, design, coding and unit testing.
Extensively involved in writing SQL queries (Sub queries and Join conditions), PL/SQL programming and Query Level Performance tuning
Generated DDL scripts for creation of new database objects like tables, views, sequences, functions, synonyms, indexes, Triggers, Packages, Stored procedures, roles and granting privileges
Tuning of SQL statements using EXPLAIN PLAN, TKPROF, Oracle Hints to improve the performance
Proficient in Oracle tools such as TOAD and SQL Navigator
Experienced in Loading data into multiple tables using DB Management Tool like SQL*LOADER, Import /Export.
Excellent communication skills and ability to develop solutions for client needs using agile methodologies.
Good Team Player, Strong Interpersonal and Communication Skills combined with self-motivation, initiative and the ability to think outside the box
MS SQL Server 2014/2012/2008 R2/2008/2005/2000, SQL Server Reporting Services 2008, SQL Server Analysis Services 2005, Oracle, MS SQL Server Integration Services 2008, MS Access, ERWIN 4.0/4.1/4.2, Windows 9x/NT/2000/XP/Server 2003/2008 R2, T-SQL, PL-SQL, Visual Studio 2008/2010, Microsoft Visual SourceSafe, HTML, ProClarity, MS Office, PowerShell, Crystal Reports 8.5/9/10, XML, Visio, Toad, SQL Profiler, Query Analyzer, VERITAS NetBackup, RedGate, LiteSpeed, SQL Sentry JDBC, TSM, ODBC, OSQL, Delphix, BMC, Attunity, APEX SQL, IBM Netezza, IBM RQMS and ALTIRIS change request system, UC4 Automation process.
Masters of Public Administration (Health Administration)
The Pittsburgh Business Times recently named CompuGroup Technologies as the overall fastest growing privately held Professional Services company and #7 overall on the Pittsburgh top 100 listing of our area’s fastest-growing, privately held companies for 2013.
CompuGroup Technologies Mission:
To help our customers create practical business benefits from IT Solutions and Provide high quality and... cost effective Consulting services (ERP, Infrastructure, Web Applications, Mainframe Systems) in all Industries domain.
CompuGroup Technologies Offerings
CompuGroup Technologies delivers senior information technology consultants to clients who need them for critical projects.
Our clients say we consistently deliver the highest quality consultants and the fastest turnaround times in the industry.
Areas of Expertise
• Project Management and Business Analysis
• ERP: SAP, Oracle, PeopleSoft
• Business Intelligence: SAP, Oracle, PeopleSoft, Business Objects,Cognos, Informatica
• Customer Relationship Management: SAP, Oracle, PeopleSoft
• Supply Chain Management: SAP, Oracle, PeopleSoft
• Database Administration: Oracle, Microsoft SQL Server, IBM DB2
• Application Development: Java/J2EE, .NET, C#, C++, Visual Basic, PL/SQL
• Mainframe Systems: COBOL, IMS, JCL, CICS