SUMMARY:

• IT experience of over 20 Years in all aspects of Database architecture, Administration, system Analysis/Reporting, Performance tuning, modeling, sizing, programming, Data warehousing and implementation using primarily, MS - SQL Server and WINDOWS.
• Expert level skills in Administering of SQL Servers and databases. Extensive knowledge in Designing, Data Modeling, Database security, Maintenance, Data Scrub/Migration (ETL using BULK programs, SSIS and SSRS), Backup/Recovery, Performance Tuning. Coding Stored Procedures, Triggers/cursors with TSQL and Reporting.
• Strong Skills in Administering Windows NT/ 2000/2008/2012.
• Worked on highly voluminous data, pressured and OLTP mission critical production systems
• Expertise in SQL advanced features like Clustering, AlwaysOn, Replication, Mirroring, SSIS, SSRS and SSAS.
• Sound experience on Monitoring and Tuning tools like IDERA, QUEST Spotlight/FogLight, SCOM.
• Seven Years of Functional and Technical experience in Telecommunication Engineering.
• One year experience managing/integrating MySQL and Oracle databases.
• Equally considered to be SQL Developer and Production DBA

TECHNICAL SKILLS:

Operating Systems: Windows NT/ 2000/2003/2008/2012, UNIX, and LINUX

Database: MSSQL(T-SQL), ORACLE(PL/SQL), UDB, Sybase and MySQL, Data warehousing, OLAP, OLTP, WebFOCUS, and MS Access Scripting Power Shell, C#, VB Script and UNIX shell scripting.

Networking: Windows, CISCO, Ethernet, Token Ring, Protocols (TCP/IP, NetBEUI, ISDN, Frame Relay, and ATM. Internet E-commerce, HTML, MS Front Page, IIS Web Server, Proxy/Firewall Security

Hardware: Compaq Proliant, Dell, IBM netservers, SUNSPARC, Toshiba, CISCO Routers, HP Printers and EMC SAN

Tools: Erwin ER, Embarcadero ER studio, Visio, Performance / Network Monitor, Power Designer, Red Gate SQL Compare, Data compare/Load, Remotely possibly, Arcserve, Seagate Backup Exec and Double Take replication monitor.

PROFESSIONAL EXPERIENCE:

Confidential,Wattsonville,CA

Senior Database Engineer (consultant)

Environment: SQL Serve 2008R2/2014, Windows 2003/2012R2,.Net, Data Warehousing SSRS/SSIS.

• Westmarine is a boating related product manufacturer and retail seller.
• My main Responsibility was to manage, upgrade/migrate SQL databases belonging to online store databases and reporting applications.
• Designed and implemented the database upgrade process.
• Installed and configured SQL Servers with MS clustering and Always ON DAGs
• Planned and moved MS Physical clusters to VM clusters.
• Implemented SSRS, ETL jobs and some crystal report interfacing.
• Performance tuned the systems.
• Automated many data integration jobs across outer systems like AS 400 and oracle systems.
• Designed and delivered reporting needs, SQL queries and automated reports using SSRS and crystal reports.
• Planned and implemented PCI related security structure to SQL and applications.
• Configured database maintenance and monitoring the DB growth.

Confidential,Richmond,CA

Senior Database Engineer (consultant)

Environment: SQL Serve 2008R2/2012, Windows 2003/2008R2,.Net, Data Warehousing SSRS/SSIS.

• Affinity Medical Solutions was acquired by Confidential Alliances.
• Main Responsibility was to migrate SQL databases belonging to data warehousing and reporting applications.
• Installed and configured SQL Servers SQL2008R2 and SQL 2012
• Planned and executed SQL servers/Databases, SSRS, ETL jobs and EDI tools
• Performance tuned many complex SQL queries.
• Migrated SSRS server, its reports and subscriptions.
• Resolved many issues related to domain and application migrations
• Carefully planned and migrated many ETL and SSIS jobs. Designed new SSIS packages to deal with data cleansing/importing and exporting.
• Automated many data flow jobs including secure FTP.
• Planned and redesigned security structure related to SQL and applications.
• Configured database maintenance and monitoring the DB growth.

Confidential,Mountain View,CA

Senior Database Administrator

Environment: SQL Server 2005/2008R2/2012, Windows 2003/2008R2,.Net, OLAP, BI/BO

• Responsible for managing high voluminous databases belonging to reporting applications.
• Installed and configured Many SQL Servers SQL2008R2 and SQL 2012
• Resolved many performance issues, with Index tuning, system tuning and software configurations.
• Stream lined the production change management process.
• Segregated TEST environment from production.
• Managed security and user access.
• Created many SSIS packages to import data from several data sources.
• Migrated databases from old servers to new servers.
• Managed and configured monitoring system.
• Managed storage for backups.

Confidential,Santa Clara,CA

Senior Database Administrator

Environment: SQL Server 2005/2008R2, Windows 2003/2008R2,.Net,Microsoft Clusters, NetApp Storage.

• Responsible for Migrations, upgrades and administering highly OLTP SQL database servers.
• Installed and configured Many SQL Servers with SQL2005 and SQL2008R2.
• Installed and configured many Microsoft clusters both active/active and active/passive
• Configured and managed transactional replication for read only and reporting databases
• Provided 24/7 support for production servers.
• Improved performance on high OLTP servers by nailing down the root causes of issues by tweaking queries, tuning hardware and software components.
• Configured monitoring tools like Microsoft Operations (MOM) and MRTG graphs.
• Configured SQL backups and NetApp snap manager for DR purpose.
• Consolidated streamlining the change management process

Confidential,Foster City,CA

Senior Database Administrator/Architect

Environment: SQL Server 2000/2005/2008 R2, Windows 2003/2008R2, Java, C#, VB and .Net,HP PolyServ clusters, Microsoft Clusters, EMC SAN.

• Being database engineering team member responsible for defining, sizing, capacity planning and architecting database systems and provide level 3 support for 600+ servers.
• Worked with many application and business people in defining requirements and provided solutions for backend database systems.
• Involved planning and implementation SQL server consolidation efforts and high available solutions using HP PolyServ clustering and virtualization.
• Installed and administered many high available clustering servers with Microsoft clustering of SQL 2008R2 on Win 2008R2 platform and SQL 2005 on Win 2003.
• Provided guide lines and necessary instructions for level 2 support DBAs.
• Setup database mirroring and replication for database DR and reporting.
• Implemented security remediation using technical security requirements (TSR) as per Confidential standards.
• Installed and configured several SQL servers and implemented maintenance plans.
• Involved in decommissioning several old systems and maintained inventory of SQL systems.
• Migrated several databases from SQL 2000 to SQL 2005 and SQL 2008.
• Performance tuned for several critical issues.
• Evaluated and recommended many monitoring tools.

Confidential,San Francisco,CA

Senior Database Developer

Environment: SQL Server 2000/2005, Windows 2003, C#, VB and .Net

• Responsible to model, design and develop databases for several web based applications.
• Involved in the requirement gathering for several applications from client/business people.
• Designed and developed SSIS packages to import and process data from several sources like text file, Excel, Access and main frames.
• Wrote numerous T-SQL stored procedures, functions and triggers as per business requirements.
• Involved SDLC process across the environments.

Confidential, Mountain View, CA

Senior Database Administrator/Architect 

Environment: SQL Server 2000/2005, MySQL, Windows 2003, Remedy, Java.

• Responsible for Architecting and designing the phased upgrade of the SQL 2000 databases to SQL 2005.
• Responsible for administering and tuning SQL servers (SQL 2000/2005) across the enterprise.
• Responsible for re-architecting the SQL server across the CRM application environment.
• Designed and implemented the database schema for customization of remedy applications.
• Wrote numerous T-SQL stored procedures and queries and optimized them.
• Integrated several database systems including MySQL and MSSQL for data flow across the organization using Linked servers and DTS/SSIS packages. Migrated SQL2000 DTS packages to SSIS packages.
• Wrote Back End batch processing jobs for data archiving.
• Installed and configured XOsoft WAN sync manager for maintaining high available standby servers. Implemented log shipping and Replication.
• Administered MySQL databases.
• Ported data to and fro from SQL to MySQL, Oracle 10i and Micro Strategy
• Performance tuned SQL servers, databases and queries. Reduced locking and blocking for several queries.
• Installed configured monitoring tools like MOM and customized Google monitoring tools.

Confidential,Mountain View,CA

Senior Database Administrator/Developer

Environment: SQL Server 2005, Windows 2003, dotNet, C# and Webstore.

• Responsible for designing the scale out solution to their Web products Events and Calendar applications for live.com
• Customized and developed their internal custom application Webstore for scaling out the back end storage using SQL server.
• Modeled, designed and implements the database schemas for Events and Live Calendar applications.
• Wrote numerous T-SQL stored procedures and optimized them.
• Integrated Data as per the Business logics requirement from various sources.
• Wrote Back End batch processing jobs.
• Supported Webstore application