Sql Server Engineer

Venky Subramaniam

(M): 408-***-****

Email: *******@*****.***

Linked-in: https://www.linkedin.com/in/venky2307

US Citizen/Open to Relocation

SUMMARY:

Database Expert providing solutions in installation, design, development, administration, upgrades of database systems.

Handled Administration of SQL Server 7.0, SQL 2000, SQL 2005, SQL 2008(R2), 2012, Sybase and Informix

Responsible for DR/HA topologies like failover clustering (2+ nodes), Database Mirroring, Replication and Log Shipping

Introduced/implemented Full Text Search for a broader and semantic based search of data.

Planned and executed upgrade exercises such as Service Pack, Hot fixes etc.

Handled fine-tuning databases in-coordination with application owners to utilize the maximum resources for Database(s) and Applications.

Introduced and implemented partitioning of data to reduce performance issues like deadlocking, and performance degradation.

Technical Skills Summary

LANGUAGES : Java, JavaScript, TSQL, Python FoxPro, COBOL

DATABASES : MSSQL Sever, Sybase, Informix, MySQL

OPERATING SYSTEMS : Windows, UNIX, Linux, MacOSX

NATIVE & 3rd PARTY TOOL : SQL Profiler, PerfMon, SSIS, DMVs, Idera and RedGate SQL Server Tools

EDUCATIONAL SUMMARY

Bachelor of Science, Osmania University, India

Masters of Computer Applications, Birla Institute of Technology, Ranchi, India.

EXPERIENCE:

VirtualPBX.com, San Jose, CA Jan 2014 –till date

Sr. Database Engineer/Architect

Analyzed performance problems using native and third-party tools within the clustered production environment.

Recommended hardware infrastructure, Database configuration, solution to ease I/O bottlenecks, improve Indexes (duplicate, unused, overlapping), and Statistics Query optimization

Documented the analysis and recommendations for overcoming/mitigating the performance issues for future reference by successors (as necessary).

Provided a hardware/software upgrade road map as part of capacity planning.

Provided tips and mentored developers to write better, optimized queries as part of the applications.

Provided recommendations for using alternate ways of implementing high-availability and disaster-recovery solutions (Clustering with AlwaysOn and/ or Availability Groups topology, Replication)

Implemented ways to archive historical data and reduce traffic on the production system.

Involved in the process of moving legacy-based systems to a reliable RDBMS system with respect to development, design, and also in moving on to open technologies.

Redefined and implemented the solutions for the scheduled jobs invoked by SQL Server Agent, by resolving conflicts in schedules.

Generated detailed documentation explaining what these jobs do while mapping out the relationships between the databases/tables involved in the process.

Developed SSIS packages to import from, and export to heterogeneous databases like Oracle etc., as part of the integration process

Implemented and managed database clustering, failover and load balance technologies as per client requirements.

Boardwalk Tech, Palo Alto, CA Nov 2009 – Sep 2013

Sr. Database Architect/Administrator

Introduced/implemented partitioning of data to reduce performance issues like deadlocking, and performance degradation.

Provided innovative technical know-how and solutions to support the company’s patented product (BCP – Boardwalk Collaborative Platform) with specific regard to the back-end database requirements (MS-SQL Server (2005/2008/2012).

Developed and maintained scripts, utility jobs, or implemented needed software for database maintenance

Established security of all databases used by the organization.

Developed standard ”Installation Checklists” to be used to build all new servers.

Created a template for capacity planning recommendations for clients based on their requirements.

Assisted developers using native tools to suggest/make necessary changes to improve query performance

Implemented new features of SQL Server 2008-R2 including table data-types, table-valued UDFs, . CTEs, partitioning (where the volume of data is high) for clients

CA Technologies. Redwood City, CA Jun 2008 – May2009

Sr. Database Engineer/Technical Consultant

Provided solutions for clients with large database environments.

Identified performance bottlenecks and provided technical solutions

Liaised with customers, offer technical solutions based on the proprietary product of CA (Clarity) and associated software

UCSF Medical Center, San Francisco, CA Dec 2002 – Apr 2008

Systems Manager

Provided database administration, consultancy, design, and development

Managed database instances, monitoring server performance

Ensured Data Security and Integrity in line with HIPAA compliance.

SMART Modular Technologies, Fremont, CA Mar 2002 – Dec 2002

Database Consultant

Managed SQL Server 7.0 databases for Gentran (EDI Translation Software) and WIPTrack

Outlined database maintenance plans for backup, integrity checks and optimization, recovery procedures.

Proposed policies for administration, management reporting, and implementing upgrades on development/production servers for RiverOne Connector software, testing and documentation.

Designed new data structures as required, developed/implemented code to support the structures using T-SQL

Agile Software Inc., San Jose, CA Jan 1998 – Feb 2002

Database Administrator

Provided Microsoft SQL Server database administration

Responsible for operational support for in-house users, enhancement requests, procedural changes for business rules/policies, management reporting, support of Agile Customer Support Websites, monitoring NT servers using NetIQ software for performance/ availability/resource usage etc., evaluation of new software, QA tests, and developing applications for Intranet/Internet.

Contact this candidate