SUMMARY

• Over 15 years of experience wif multi - terabyte data warehouses and high availability transaction processing systems.
• Experienced in installing, configuring, administering & managing large databases, large-scale SQL Server 2012/ 2008 R2/2008/2005/2000/7 environments, Oracle 11g/10g/9i/8i databases.
• Good experience in designing, implementing and managing high-availability & disaster recovery solutions utilizing Microsoft SQL Server 2005/2008 R2/2012 Failover Clustering, Always On Availability Groups, Database Mirroring, SQL Server Log Shipping, Transactional replication etc.
• Good experience in providing cost TEMPeffective database solutions based on customer need dat include Database servers virtualization, Physical to Virtualization (P2V), consolidating databases, SQL Server instances to shared environment.
• Strong experience in capacity planning, database provisioning and Performance monitoring & Optimization etc.
• Strong experience on Database modeling for E/R (Logical and Physical), Multi-Dimensional Database (OLAP).
• Strong MS SQL Server development skills; experience writing queries using T-SQL, SQL Plus, PL/SQL, dynamic SQL, Stored procedures, functions, triggers, XML, SQLCMD, WMI, PowerShell 2.0, Shell Scripting and MDX etc.
• Experience in designing and implementing Extract, Transform, and Load (ETL) solution, Data Integration and Workflow Solutions using Microsoft SQL Server Integration Services (SSIS), Data Quality Services, and Master Data Services.
• Experienced in developing and implementing OLAP Cubes using Microsoft SQL Server Analysis Services (SSAS) dat include Designing dimensions and relationship, designing measures, measure groups, aggregations, partitions and Perspectives etc.
• Experienced in Report authoring and deployment using Microsoft SQL Server Reporting Services dat include creating tabular, matrix reports, used charts, KPI for dashboards and used most common data sources.
• Strong experience in Master data Management (MDM), Data Governance, Data Warehouse, KPI, Scorecard, Dashboard and SharePoint 2010 BI Integration.
• Good experience in implementing and managing SQL Server Replication including Merge, Transactional, Snapshot and Peer to Peer replication.
• Specialized in producing a detailed audit of a SQL Server environment, taking into account in terms of compliance or to meet enterprise security policies.
• Expertise in database migration from Oracle 10g/11g to SQL Server 2008/2008 R2, MS Access, MySQL 5.1 to SQL Server 2008/2012 .
• Good experience in implementing and managing Microsoft Windows Server 2012/2008 R2/2003/2000 server infrastructure, RHEL 4x and 5x servers and setting up and managing web sites using IIS 7/6/5 servers, Apache and Tomcat servers.
• Good Understanding Storage Area Networks (SAN) including EMC VMAX FAST VP, NetApp, Hitachi USP SAN storage.
• Experienced on designing, implementing and managing SharePoint Portal server 2013/2010/2007 Server Farm infrastructure.
• Strong experience in database modeling wif ERWIN 8.2/9.0, Microsoft Visio 2013/2010/2007 and Project Management
• Experience in System Monitoring, Incident management, Change Management and Release management using BMC Remedy, BMC Patrol, CA NSM, NetIQ, Cacti, and SCOM etc.
• Experienced in system and database auditing and good noledge of SOX, HIPAA compliance.
• Posses strong analytical and Project Management Skills, Good Leadership skills and Communication skills, Proven analytical abilities wif attention to detail and ability to work TEMPeffectively in a fast paced environment.

PROFESSIONAL EXPERIENCE

Confidential

Sr. SQL Server DBA

Responsibilities:

• Provide expert guidance on Database/Business Intelligence solutions using Microsoft SQL Server technologies.
• Develop scalable and maintainable Database/BI applications to meet business objectives.
• Installed and Configured SQL Server 2012/2008R2 software, implemented SQL Server 2012/2008 R2 Failover Clustering, AlwaysOn Availability Groups, Database Mirroring etc.
• Involved in designing and implementing database infrastructure solution for Allscripts Enterprise EHR application for Confidential Health System using SQL Server 2008 R2 technologies. Solution involves database sizing for large databases over 2 TB, High Availability and Strong DR strategy using multinode SQL Server 2008 R2 Failover Clustering instances, Database mirroring, Transactional Replication, strong Backup and Recovery strategy using TSM, Native backups, configured and optimized for VLDB databases.
• Involved in database modeling and design for Clinical Data warehouse database using Snowflake schema.
• Involved in creating ETL architecture developed ETL Packages to load data from multiple data sources, different flat file data sources wif complex transformation logic. Packages implemented wif features include complex error handling, notification, SCD etc. using SQL Server 2012 Integration Services.
• Managed Allscripts Enterprise EHR, Sunrise Clinical Manager, Sunrise Clinical Analytics application databases and involved DR Implementation, Database maintenance, code promotion and SSIS Packages, SSAS Cube and Report deployment etc.
• Migrated 500 GB of SPARCS database (Oracle 11g) to SQL Server 2008 R2 database. Part of teh project, migrated most of oracle objects including PL/SQL packages to SQL Server database and tune teh database for better performance.
• Design, install, patch, upgrade and tune multi-terabyte database infrastructure using: SQL Server 2005, SQL Server 2008 R2 and SQL Server 2012.
• Contribute wif teh design, launch, and execution of IT disaster recovery strategy and program. Implement IT application support business continuity plans.
• Worked on monitoring performance and Troubleshooting SQL Server database issues. Identified performance bottlenecks caused by major concurrency / blocking issues of which most were caused by sub-optimal indexing, addressed poorly written queries, Disk contention issues, System Resources bottlenecks etc.
• Created/developed drilldown/drill through reports, Chart, Dashboard reports using SQL Server 2008 R2/2012 Reporting Services.
• 24/7 On-call production support.

Confidential

Sr. SQL Server DBA

Responsibilities:

• Providing technical consultancy and implementation guidance on database architecture, design & development.
• Engaging wif clients to provide strategic & cost TEMPeffective solution to technical and business problems.
• Involved in designing and implementing complete mobility solution using SQL Server 2008 Merge replication wif web synchronization technology and SQL Server Compact edition 3.5 software running on Windows Mobile (Motorola MC75A devices).
• Worked on Microsoft Dynamics CRM 2011 implementation project. Part of dat, Involved in designing and implementing SQL Server and SharePoint Application and ADFS infrastructure using SQL Server 2008 R2 Failover Clustering and SharePoint 2010 Farm technologies on Windows Server 2008 R2 Environment.
• Worked on Merge replication performance issues and improved synchronization performance by reducing teh sync failures from 40% to 10%.
• Worked on Customer asp.net application performance issues numerous, identified performance bottlenecks caused by major concurrency / blocking issues of which most were caused by sub-optimal indexing, addressed poorly written queries and Session timeouts/ session management issues wif Load Balancing device.
• Responsible for numerous OLTP and DW SQL production databases up to 1TB in size.
• Installed and configured SQL Server 2005and SQL Server 2008 Servers according to best practices.
• Worked on Factiva Metrics data warehouse migration project, part of teh project, migrated data warehouse databases, ETL Packages (SSIS Packages), SSAS Cubes and SSRS Reports to new server infrastructure running SQL Server 2008R2 from SQL Server 2005.
• Worked on SQL Server migration project, part of dat migrated SQL Server 2000 databases to SQL Server 2005 and SQL Server 2008 databases and migrated its associated jobs, SSIS packages and full-text indexes, setting up Transactional replication and Database mirroring etc.
• Involved in monitoring and troubleshoot SQL Server database performance problems, fine-tuning of databases and indexes, stored procedures etc.
• Working on Capacity Planning Project, part of dat gatheird CPU, Memory and Space utilization metrics for 400 Production Oracle, Microsoft SQL Servers, MySQL, Informix and DB2 database servers from CACTI monitoring and created projections using SQL Server 2008 Analysis Services Data mining and create reports using Reporting Services.
• Created Drill down, Drill through, and Parameterized reports using SSRS.

Confidential, Bridgewater, NJ

Sr. SQL Server DBA/Data Architect

Responsibilities:

• 24X7 production support. Led migration from SQL 2000 to SQL 2005 & 2008 across entire infrastructure, resulting in better performance, scalability, application flexibility, and ability to troubleshoot problems.
• Reduced infrastructure costs up to 30% by consolidating over 50 underutilized SQL Server instances to Shared infrastructure running SQL Servers 2008 and converting large number of Physical servers to Virtual environment running VMWare.
• Build and Implemented multiple two node, four node SQL Server 2005/SQL Server 2008, SQL Server 2008 R2 Failover clusters on Windows Server 2003/2008 as part of High availability solution for business critical applications as well as MOSS 2007 (Sharepoint) farms, Project Server 2007, SCCM 2007, NETIQ, Enterprise Vault, Blackberry applications.
• Implemented database mirroring, Transactional replication on SQL Server 2008/2005 databases part of database high availability solution.
• Worked wif application team on implementing Sterling Commerce Order capture application (E-Commerce) on SQL Server 2008 Database and also implemented Web Synchronization for merge replication for Sales force team pocket devices.
• Involved in implementing and supporting data warehousing and BI projects using Microsoft Business Intelligence suite for X-Factor (Managed Markets), WISDOM projects. Part of project, involved in business requirements, identifying data sources and data quality issues, schema design, ETL design and implementation using SQL Server Integration Services (SSIS). OLAP cubes implementation using SQL Server 2008 Analysis Services (SSAS) and used SQL Server Reporting Services and excel services for reporting purposes.
• Worked wif development team on migrating Oracle 10g database to SQL Server 2008 database, migrated all oracle objects including PL/SQL packages to SQL Server database and tune teh database for better performance.
• Developed in-house SQL Server monitoring and alerting application using SQL Server 2008 technologies.
• Responsible for maintaining, monitoring SQL Server instances & databases and troubleshooting SQL Server performance issues.
• Build and implemented multiple two node SQL Server 2005 Failover clustering as High availability solution for Production, QA Environments. Migrated large number of databases from standalone shared servers to clustered instances as part of server consolidation and availability.

Confidential, New York

SQL Server DBA/Developer

Responsibilities:

• Developed and implemented sound database upgrade/Migration plan for large number SQL Server 2000 servers to SQL Server 2005.
• Developed Database Standards to ensure developers and programmers were following best practices and good coding standards. Responsible for teh code promotion of database objects throughout teh different environments.
• Implemented and managed SQL Server databases for MOSS 2007 (Sharepoint) and MOSS 2003 for departmental portals, employee time reporting systems etc.
• Involved in implementing and supporting data warehousing and BI projects using Microsoft Business Intelligence suite such as SQL Server 2005 Integration Services (SSIS), Analysis Services (SSAS) and Reporting Services (SSRS).
• Worked on multiple database projects and involved in database modeling, database design and development using T-SQL, XML for ASP.net applications.
• Worked on multiple projects on building reports using SQL Server 2005 reporting services (SSRS), Business Objects Crystal Reports. Support and debug asp.net applications using Visual Studio 2005.
• Involved in migrating to SQL Server 2005 servers from SQL Server 2000 servers, migrating SQL Server 2000 Failover Cluster (4 node cluster) to another datacenter.
• Involved in Implementing and managing SQL Server 2000/2005 Failover Clustering, SQL Server 2005 database mirroring, transactional and snapshot replication for critical applications.
• Worked wif Data Warehousing team to design and model data warehousing database and develop ETL Scripts, migrated DTS Packages to SSIS packages, building new packages to extract data from Visual FoxPro, DB2, text based sources using SQL Server Integration Services for transforming and populating data to data warehouse.
• Created and optimized database objects (tables, Indexes, views, user defined functions, stored procedures & triggers) using T-SQL and supporting development team.
• Automated daily administrative tasks and created, tested and Implemented DR plan.
• Assists wif establishing policies and procedures pertaining to database management, security, maintenance and utilization. Worked wif auditing team on SOX compliance.
• Worked wif Enterprise Integration teams to implement SQL Server databases for BizTalk 2004, SharePoint 2003 applications, implement web services interaction between heterogeneous systems.
• Involved in business analysis, database design and development for teh 3 applications (Asp.Net/SQL Server 2005 Backend).
• Providing DBA support for scheduled releases, emergency changes, troubleshooting, database optimization, disaster recovery planning, hardware/software upgrades, and database migration.
• Interfaced wif Business Analysts in gathering business requirements. Designed user-friendly templates to communicate additional enhancements.
• Created and optimized database objects (tables, indexes, views, user defined functions, stored procedures & triggers) using T-SQL, SQL Plus
• Involved in managing and supporting SQL Server instances/databases using SQL Server 2000/2005 Failover Clustering, transactional and snapshot replication etc.
• Responsible for cleansing and loading OLTP data to teh date warehouse system. Built teh re-usable mappings using T-SQL scripts, ActiveX scripting and SQL Server Integration Services packages.
• Administered and managed SQL Server Analysis Services 2000 for OLAP and built reports using SQL Server Reporting Services.
• Provided data architecture mentoring and general software architecture guidance.
• Involved in maintaining, testing and debugging teh Asp.net applications using Visual Studio 2005/IIS 6.0.

Confidential

SQL Server DBA

Responsibilities:

• Planned and installed Microsoft SQL server 2000 servers in windows 2003/2000 environment.
• Involved in maintaining and managing Oracle 9i/10g databases in Linux/Solaris environments.
• Involved in implementing and managing SQL Server 2000 failover cluster, SQL Server log shipping as high availability solution for SQL Server databases.
• Created and optimized database objects (tables, indexes, views, user defined functions, stored procedures & triggers) using T-SQL, SQL Plus
• Worked wif Apps development team on implementing releases, patches and provided development support.
• Designed automated ETL processes including data extraction, transformation and data loading required for data warehouse application.
• Prepared Quality Management Standard documents for Microsoft SQL Server 2000 to meet eBis and SOX compliance.
• Involved in planning and implementing SQL server 2000 servers, Oracle 9i databases and supporting development team.
• Automated and enhanced daily administrative tasks, including space management, object alteration, backup & recovery and performance monitoring.
• Created and optimized database objects (table, rule, defaults, views, user defined functions, stored procedures & triggers) using T-SQL
• Supported Maximo 4.1 application and worked on creating reports using crystal reports 7.0
• Responsible for teh creation and optimization of DTS packages for importing, exporting and scrubbing data from heterogeneous sources.
• Responsible for implementing and supporting Accounting & Finance, Sales & Distribution apps from JAWA software (Oracle backend).
• Installed and configured SQL server 7.0 database servers, upgraded from SQL Sever 6.5 versions to SQL Server 7.0 Servers.
• Involved in patching, applying bug fixes and keep teh servers are up to date.
• Involved in setting up and implementing strong DR strategy for SQL Server databases.
• Worked closely wif teh Application Development team and supported and resolved database connectivity issues, performance issues etc.
• Responsible for monitoring and troubleshooting SQL Server databases and automated database maintenance activities using database maintenance plans.