OBJECTIVE

• I’m looking for a challenging position in RDBMS (OLTP), OLAP, Data Mart/Data Warehouse, Internet/Intranet and client/server technologies. I have working experience with small size to corporate companies.
• Over 15 years of experience in the IT field and over 8 years of DBA experience in various domains like Finance, Health Care, Mortgage, Network, Digital Print Media, Antivirus Software, Wafer Manufacturing Industry,Utility and E - commerce industries.

SUMMARY

• Over 8 years’ experience in architecting, designing, implementing and supporting OLTP and business intelligence solutions.
• Over 8 years of SQLSERVER DBA experience in various projects.
• Strong experience in Replication Services,DB Mirroring, Database modeling, DB Cluster Node Management and Performance Tuning.
• Over 4years experience with SQL SERVER 2012/2014 with AlwaysON technologies.
• Setup and maintain Database Snapshots using NetApp SAN tools, SnapDrive and Snap Manager SQL.
• Having a good experience with SQL Server Service Broker
• Over 12 years of experience in T-SQL coding and 10 years of PL/SQL coding
• Over 4 years of MANUFACTURING EXECUTION SYSTEM Eyelit software and DB integration experience with various Projects.
• Over 4 years of experience with AWS cloud computing platform, MS AZURE cloud technologies.
• Over 10 years of experience with VM ware client and server technologies.
• MS TFS2012/2015 migration experience
• Strong experience in Data migration from SqlServer2000/DB2 SQSVR2005/SAP, ORACLE10i ( SQLSVR2005 and SQLSVR2005 SQLSVR2008 R2 Enterprise
• Strong working knowledge in Sqlserver 2014/2012/2008/2005/2000 with cluster server environment
• Over a year QlikView Administration Experience
• Strong working knowledge of DBA Roles like Backup, Restore, Export, Import, Data Archiving and setting up Proxy accounts for SSIS etc.
• Expertise working with cursors, triggers, User defined functions, DTS Packages, Stored procedures, Reporting services (SSRS) and Report builder, Integration services, Analysis services
• Experience in User support, requirement specifications, documentation, third party software integration, implementation, troubleshooting and mentoring
• Excellent logical and analytical skills with the ability to work under pressure. Strong communication skills and an ability to work individually or part of a team

TECHNICAL SKILLS

Operating Systems: Windows NT 4.0/2000/2003/2000/ XP/2008/WINDOWS7, UNIX

Languages: SQL, T-SQL, PL-SQL, MDX, C#, ADO.NET, ASP.NET, VB.NET

Databases: MS-SQLServer 2000 thru 2016,TeraData, Oracle9i/10G/11G, MySQL,MS Access,MongoDB,MicroStrategy

IDE/Tools: Visual Studio 2008/2005/2003 , Business Intelligence Development Studio (BIDS)

Web Servers: IIS 6.0/5.0, Glass Fish Database Design Tools Erwin, MS-VISIO

Version Control Tools: TFS 2008/2010/2015 , Visual Source Safe 2005/6.0, Source Gear Vault, Clear Case, PerForce (P4V)

Debuggers: Visual Studio Debugger, Bugzilla, HP Quality Centre, Jira

Reporting Tools: Crystal Reports 10/9/8.5, MS Reporting Services (SSRS), Qlikview 10.0, Tableau 9.2

Communication Tools: MS-Office Live meeting 2007, WEBEX, SHAREPOINT SERVER

PROFESSIONAL EXPERIENCE

Sr. Lead DBA

Confidential

Responsibilities:

• 1.Supporting in Sql Server as a DBA (Sql Server 6.5 2014) in Virtual, Cloud and Physical servers environment
• 2. Supporting in both Development,QA & Production environemnt. Mantaining SOX compliance to meet audit standards.
• 3. Working between business analysts/stakeholders/subject - matter experts and development staff to architect database solutions.
• 4. Supporting high availability options including Clustered Sql Instances, AlwlaysOn, Database Mirroring, Log-shipping and Custom Warm-Standby servers. Configure and manage loadbalancing for SQL server Always On groups by using Azure internal load balancer
• 5. Monitoring and production experience with replication (Transactional).
• 6. Managing and Deploying TSQL Stored Procedures, UDFs, Triggers, Views.
• 7. Normalization, Design, Table & Constraint Implementation.
• 8. Use of Embarcadero ERStudio and use of Redgate Sql/Data Compare. Performance tuning, Bottleneck resolution, Debugging with Index Analyzer, Sql Profiler, Windows PerfMon.exe, Sql Server Debugger and execution plans.
• 9. Transaction handling and SQL Load balancing by using ScaleArc.
• 10. Backup & Maintenance, disaster and recovery planning & Implementation
• 11. Support for Crystal Reports and SSRS.
• 12. Managing Linked Servers within SQL Servers and cross servers like SQL SERVER to ORACLE. SSIS package management including Sql Server Integration Services Catalog management.
• 13. Working Closely with Development Team, analysts and programmers in n-tier and front-end (ASP web& client/server) development.

Sr.DBA & Tableau Admin and Developer

Confidential

Responsibilities:

• Primarily supporting on Marketing Data Process and Operations team on Data Extractions (ETLs) from various data source like Oracle,FTP,Excel and SQL Server.
• Developing and managing Tableau Dashboards like Scheduling jobs, Refreshing Dashboards and Managing User accounts
• Analyzing various Dashboards data and reporting to management on issues that are identified every week.
• Managing as an admin on Tableau, SQL Server2008 R2 servers.

Sr. SQL Server DBA

Confidential

Responsibilities:

• a wholly owned subsidiary of Confidential Corporation, is the world's premier provider of piezoelectric inkjet print heads.
• Our products are designed to accurately dispense a wide range of fluid types in micro-amounts for demanding imaging and fabricating applications.
• With more than 27 years advancing the performance of drop-on-demand dispensing devices and applications,
• Confidential Dimatix is the only developer and manufacturer in this industry with the technology, know-how, and creativity to lead the industry into the future.

Sr. SQL Server DBA

Confidential, Mountain View, CA

Responsibilities:

• 1) Successfully done Data migration from Sqlserver2005 to Sqlserver2008R2
• 2) Auto renewal project migration from MS - Access to Sqlserver2008
• 3) SPA (store Performance Analysis) Integration and automation
• 4) Daily database backup, Replication, SQL Agent Jobs monitoring
• 5) Make sure that high availability of data and SERVERS.
• 6) Developed SSIS packages for daily data load from various places like

Sr. SQL Server Developer/DBA

Confidential, Santa Clara, CA

Responsibilities:

• Monitoring SQL jobs, Performance bottlenecks, configuring databases, backup/restore DBs.
• Used dynamic SQL to reuse the code part of the stored procedure. Implemented Transactions like BEGIN/ROLLBACK/COMMIT based on the needs. Key feature in Dynamic SQL like Paramdefinition to define it as output and retrieve it by using SP EXECUTE SQL.
• Used open query commands in Stored Procedures to update data in TeraData.
• Using TFS (Team Foundation Server) to maintain the all SQL code, to build for each release in various environments. Participated part of the build/release process in various environments.
• Installed, Configured SQL SERVER REPORTING SERVICES, SSAS. Migrated all Crystal Reports to SQL SERVER REPORTING SERVICES to better perform and reduce the cost. Build Multi dimensional cube using SSAS and used advanced DAX calculations for Measures and KPIs
• Used Information Schema views, SYSTEM. Triggers, SYS.dependencies for various database application needs to verify the common columns/Key columns list between the tables, finding the triggers list on a table and finding the dependencies of an object.
• Implemented different types of Replication Models like Snapshot, Merge and Transactional using SQL SERVER2008.
• Used performance tools like Index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance. .
• Used Common Table Expressions (CTEs) to avoid sub queries.
• Added error handling techniques like TRY-CATCH in the procedures.
• The HP Quality Center tool used to track the bugs and to get the consolidated bug reports.
• Involved in the Database design and creation of tables, stored procedures, User Defined Functions, SSIS packages using SQL Server 2008.
• Scheduled the reports to run on Daily/weekly basis to deliver sales and business teams via email. All reports generated using Microsoft SQL Server Reporting Services.

Sr. SQL Server DBA

Confidential

Responsibilities:

• Monitoring SQL jobs, Performance bottlenecks, configuring databases, backup/restore DBs.
• Wrote ETL scripts using SSIS to process the lender data which co Manufacturing Execution System in XL, xml, pdf format and that Load it into the Data Factory.
• Configuring file groups on SQL SERVER 2008 R2 to deliver better performance.
• Running Alerts on all production Databases to make sure that enough space is there.
• Configured DB mail and set up email alerts using it.
• Windows server administration
• Did Data mining to help Mortgage Statistical data analytics.
• Using SQL SERVER REPORTING SERVICES to generate Reports like how the single family/condo property sales doing at Metro Area/County/Zip level for Business needs.
• Implemented different types of Replication Models like Snapshot, Merge and Transactional using SQL SERVER2008.
• Using performance tools like Index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
• Developed various reports using SQL SERVER REPORTING SERVICES and SSAS and rolled out to all Confidential mortgage clients.
• Used Geo spatial functional calculations to get best comparable based on client given property details.
• Used Tally table to avoid looping and to improve performance.
• Used CTE (common Table expression to avoid sub queries).
• Added error handling techniques like TRY-CATCH in the process.
• Used VS2005 Team Foundation for DB professional’s tool for version controlling.
• Raidster internal tool used to track the bugs and to get the consolidated bug reports.
• Involved in the Design of Database and creation of tables, stored procedures, User Defined Functions, DTS packages using SQL Server 2005, 2000.
• Scheduled the reports to run on a weekly basis and set up them to deliver to sales and marketing teams via email. All reports generated using Microsoft SQL Server Reporting Services.

Sr. SQL Server Developer/Application DBA

Confidential, San Jose, CA

Responsibilities:

• Scraper: Using keywords bucket at entity/country level .It sends an http request to the search engine using a pool of proxies. SE populates all natural search results. Scraper parses all the results and loads in the database.
• Use of the proxies in an innovative way (thus, not tying one application server to one proxy but to all). Use the same technique used in SOV that distributes the load to all proxies. The technique not only randomizes but also vastly distributes the HTTP requests and thus avoiding Google detection.
• Once data got populated in the Database, using SQL Server Reporting services generates various reports to the abbey at site/country level. These reports use various stored Procedures, Functions, Views which are written in T-SQL .Above all reports delivered in XL sheet to the business users via email
• After that all transaction keyword data pushed to Data ware House using SSIS (ETL) technology to do further analysis by business users.
• Monitoring SQL jobs, Performance bottlenecks, configuring databases, backup/restore DBs.
• Wrote complex ETL scripts using SSIS to push the SOV data from the transactional database to DW on a regular basis. Involved in database design and implementation.
• Did Data mining to help Data warehouse/Data mart team for further analysis of keyword data
• Involved in Star Schema design and Implementation.
• Used SSAS to generate Reports for Business needs
• Implemented different types of Replication Models like Snapshot, Merge and Transactional.
• Using performance tools like Index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
• Developed about 120 reports using SQL SERVER REPORTING SERVICES and SSAS and rolled out to 30 Confidential International sites.
• T-SQL. Added error handling techniques like TRY-CATCH in the process. Used Clear Case tool for version controlling.
• Bugzilla tool used to track the bugs and to get the consolidated bug reports.
• Involved in the Design of Database and creation of tables, stored procedures, User Defined Functions, DTS packages using SQL Server 2005, 2000.
• Scheduled the reports to run on a weekly basis and set up them to deliver to sales and marketing teams via email. All reports generated using Microsoft SQL Server Reporting Services.

Environment: VisualStudio. NET 2005, Framework 2.0, C#, ASP.NET, ADO.NET, Perl, SQL Server 2005, TeraData,MYSQL IIS 6.0, JavaScript, XML, Win 2003, Clear Case.