Post Job Free
Sign in

Sql Server Developer

Location:
Fairfield, CA
Posted:
March 05, 2016

Contact this candidate

Resume:

*

SUMMARY OF EXPERIENCE

More than ** years of experience in IT. I have more than 14 years of experience in Designing Database solutions, Developing Databases, operational database administration, High Availability Solutions (Cluster, database mirroring, Replication), Disaster Recovery solutions (HADR, log shipping), System Performance, Performance Trend Analysis, Trouble shooting, Backups and Recovery, SQL Server Profiling, Data Quality, Database Design, Architect, Business Intelligence, ETL, Database development. Experience in scale up and scale out the SQL Server solutions. I have experience in creating complex reports using Crystal reports, MS Access and SSRS.

Business Intelligence experience includes managing Analytical server (SSAS), ETL, Integration Services

(SSIS), SSRS, Managing and creating cubes, also partitioned cubes. I also have experience in data analysis, data migration & data cleansing.

I have around one year of experience as “Big data” Hadoop developer and administrator. Microsoft Certifications

Microsoft Certified Solutions expert in SQL Server 2012.

Microsoft Certified Solutions Associate in SQL Server 2012.

Microsoft certified professional in the following certifications.

Administering Microsoft SQL Server 2012 databases.

Querying Microsoft SQL Server 2012.

Implementing Data Warehouse with SQL Server 2012

Designing Database Solutions 2014

Developing MS SQL Server Databases 2014

TECHINCAL SKILLS

Languages: COBOL, C, C++, TSQL, SQL, PL/SQL, DB Library, .NET 3.5,NET.4

RDBMS: MS SQL Server 2012/ 2008/2005/2000/7.0/6.5, SYBASE 10/11, Oracle,DB2, MS Access

OS: Windows 2008/2003/2000/NT/VISTA/XP/98/95, UNIX, MS-DOS, Novell Netware

GUI: VB.NET, ASP.NET, Delphi, Power Builder, VC++ (MFC) 4.0, Crystal reports

Internet: Java, JSP, JavaServlets, HTML, Visual InterDev, JavaScript, VBScritpt, ASP, XML

Servers Tools: MTS, MSMQ

Database Tools: Embarcadero, Red Gate, DBArtisan, Veritas, Erwin, Visio, SSMA

Security Tools: MBSA, ISS

Monitoring Tools: Confio, SQL Monitor from Redgate SRINIVASU VEERAIAHGARI (SRINI)

US Citizenship

408-***-**** (Cell)

*****@************.***

2

Storage: SAN, NetApp

ERP Applications: PeopleSoft, J D Edwards, One World, and Oracle Applications. PROFESSIONAL EXPERIENCE

SoftPreneurs Inc., Nov 2011 – Current

Lead/Sr. SQL DBA/Developer

Administered, Supported the SQL servers, databases of the following clients Driscoll’s, California Teachers Retirement Systems, Berkshire Hathaway home state companies, and Leapfrog. Implemented high availability, Scale up and Scale out solutions. Managed SQL servers over 1 TB database sizes. Developed automated programs using TSQL and PL/SQL for manual processes. Fine-tuned the store procedures, indexes, server configurations, database configurations etc. Also programmed ETL using SSIS. Developed cubes. Developed reports using SSRS. Worked on Data Quality and automated programs to do the data quality checks. Developed complex stored procedures, functions, triggers, views and queries. Built warehouses and data marts. Also maintained

.Net applications.

Technologies & Tools: SQL Server 2012, SQL Server 2014, Microsoft Azure,SQL Server 2008 R2 (64 bit), PL/SQL,SQL Profiler, Big data (Hive, pig, Sqoop, Hbase, Mongo DB, Map Reduce, HDFS) Performance Monitor, Confio, SQL Monitoring tools by Red gate, SSRS, SSIS,SSAS,SSMS,.NET, MVC,C#, MySQL etc., Electronic Arts, Redwood City, CA June 2009 – August 2011 Sr. SQL Server DBA (Operations)/Data Architect/BI Developer Electronic Arts is the leading game developer. I have involved in migrating In-game advertising product from Third Party Company to EA. I have involved in PC & Xbox platform in- game advertising products for EA. I have worked as team lead for this product migration. I have installed and managed 4 node and 2 node SQL Server 2008 clusters. I have upgraded SQL Servers from 2005 to 2008 version. Worked as data architect/data modeler also and built OLAP cubes. I have built SSIS packages to migrate data from OLTP to Data Warehouses. Responsibilities:

Planning, installating and configuration MS SQL Servers.

Setup Development, Test, Integration and Production servers.

Developed and tested Disaster Recovery strategy.

Implemented and managed Log shipping.

Performance Tuning & optimization.

Develop cubes and SSRS reports.

Developed SSIS packages.

Data Analysis, Data Migration and Data Cleansing.

Install and maintain OLAP Servers.

Database design & Write the store procedures.

Managed OLTP and data warehouse systems.

ASP.NET programming little bit. Compile, Debug and deploy the asp.net apps.

Talk to business users for requirements & knowledge transfer on application usage. Technologies & Tools: SQL Server 2005/SQL 2008 (64 bit), ETL, SQL Profiler, Performance Monitor, OLAP, clustering solutions, Log Shipping, C,C++, ASP/ASP.NET, Network Protocols HTTP, Share Point 3

Softpreneurs Inc, Bay Area, CA December 2005 – June 2009 SQL Server DBA/Data warehouse DBA/Data Analyst

I have done SQL Server operational database administration includes installation and configuration, upgrading to SQL Server 2005, set up database mirroring, log shipping, replication, clustering. Recently I have also installed and configured 4 Node/2 Node DB cluster for Electronic Arts. Also I have performed database maintenance, performance audit, and backup and restore policy, security audit, database fine turning and query tuning. I have been contracted by IBM to provide SQL Server consulting for their client. My responsibilities include installation, deployment, development, test and production servers and later on to do performance tuning of those databases and also support business intelligence product. The database size is around 350GB and 3 Billion records. My responsibilities include support & maintain IIS web Server and Crystal Report Server XI.

During this period of time with softpreneurs Inc, I worked at their clients and they are University of California Medical Center, San Francisco, Department of Parks & Recreations

(California State), I home finder Inc., Mechanic Net Inc., Certain Inc., Ramsell Corporation Inc., and IBM,

Technologies & Tools: SQL Server 2005/SQL 2008 (32 bit and 64 bit), Oracle, PL/SQL, SQL Profiler, Performance Monitor, OLAP, clustering solutions, Database Mirroring, Log Shipping, Replication, Business Intelligence, Visual Studio 2005/2008, .NET, ASP.NET, C#, IIS etc., Leapfrog, Emery Ville, CA Aug 2005 – Sept 2005

Performance Audit/Tuning

Leapfrog had performance issues on production SQL Server. I did performance audit on SQL Server and fine-tuned the SQL Server. I also fine tuned the ETL SQL Scripts. Technologies & Tools: SQL Server 2000, SQL Profiler, PerfMon, Informatica. Commission on Peace Officers Standards and Training (POST) Jan2004 – July 2005 Sacramento, CA

Online Course Certification (EDI)

POST is developing web application to replace manual course certification process and course roster. I worked as database analyst to help them design the database structure (logical and physical), data analysis, data migration, data cleansing, develop database dictionary, develop mockup screens, support development, test, staging and production Servers, capacity Planning, migrate the data, program triggers and store procedures etc. I was involved reports development as well. My Role: Project Leader in Database Administrator, Database Analyst. Technologies & Tools: SQL Server 200, Vision, ASP.NET, .NET Technologies, Crystal Reports. California Cancer Registry/PHI, Sacramento, CA November 2001- December 2003 Eureka

4

PHI/CCR developed a product, which is a centralized database for California Cancer Registry. My responsibilities included migrate cancer patient’s data from all the regions into a centralized database, set up standby server using log shipping, Design and maintain the database, optimizing the Server, fine-tune Database and fine tuning Store Procedures. This migration involved working with 1 Billion records and around 200GB Database size. Implemented distributed partition views and archiving the data for improving the performance of database. Gathered Requirements, analyzed, Designed, and Developed the Data Marts for cancer research. I have also involved development of crystal reports and setting up crystal enterprise server. My Role: Database Administrator, Data Migration Specialist, Crystal Report Writer and Application Fine Tuner.

Technologies & Tools: SQL Server 2000, Oracle 8i/9i, IIS, Windows 2000 Advanced Server, SAS, MTS, MSMQ, C#, Delphi, ASP. Net, MTS, COM+, DCOM, Crystal Reports Enterprise Suite, Embarcadero Tools, Red-Gate Tools, Microsoft Security Baseline Analyzer, ISS, JavaScript, DHTML, HTML, CSS etc.,

Hardware: Compaq/HP- Proliant ML 570, Proliant ML370 MAT Systems Inc., Denver, U.S.A. February 2001 – November 2001 www.eTradelan.com

This is a B to C product. The product mainly deals with on-line shopping mall. The products have two major modules, the Sale side and the Admin Side. The sale side is the User entry level, by which he can do his shopping with any store of his preference. The admin side is the area where all the details about the store and the users are maintained. My Responsibilities:

Estimated the space required. Creating and managing schema objects such as tables, views, indexes, procedures, triggers, and maintained referential integrity. Attaching and detaching the databases. Administering the MS SQL Server by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups. Assigning the users to particular groups, security and auditing on SQL Server. Managing the use of disk space, memory and connections, Running DBCC consistency checks. Database backups and restoration. Migrating Data from Oracle to SQL Server. Importing and Exporting of database using DTS Import, DTS Export. Trouble shooting SQL Server. Designed and OLAP applications. Managing Internet Information Server. Created Java classes for mapping the database tables.

My Role: SQL Server DBA, Java Developer, Q A Engineer Technologies & Tools Used : Java, Java Servlets/Beans, JSP, Forte, IBM Websphere, XML, JavaScript, HTML, Oracle, MS SQL Server 2000, IIS, DB2, Oracle, Windows NT Inleague Inc., California. U.S.A July2000-February 2001 Inleague.com & Reports Web Server & 50 State Tax Reporting 5

InLeague, Inc. offers a superior nationwide payroll outsourcing service, leveraging technological advances, including the Internet, to achieve low-cost, robust and easy-to-manage solutions for its customers. Through extensive automation and a smart, flexible database platform, Inleague’s solution marks a fundamental change in the payroll industry landscape – providing clients with compelling cost savings, accuracy, and reliability, ease of data access, integration and efficiency. These benefits are critical to important constituent groups: employers, employees, employee benefits providers, and tax authorities. InLeague enables you to process payroll in a shorter time and with a higher degree of accuracy than previously attainable. My Responsibilities:

I involved in SQL Server administrative tasks. Monitoring MS SQL Server performance and network issues. Created the complicated Stored Procedures for State and Federal Tax Reports.

I have developed the most important reports of the Payroll application Using Crystal Report Engine module. I have created lot of sub Reports. I was involved in creating and modifying the Paycheck, Payroll summary and Payroll audit and different Tax Related Reports My Role: SQL Server DBA, Database Developer, Crystal Report Writer, Software Developer & Web Developer, Q A Engineer

Technologies & Tools Used: Visual Basic 6.0, Crystal Reports 8.0, MS SQL Server 7.0, Java, IIS, Windows 2000, Active X, COM, DBArtisan, and VB Script

CPI Inc., California, U.S.A July 1998 – June 2000

CPI Directory, Q A System, MRD, Data Migration & Check Writer Program. I have developed Q A System for CPI. It’s description as follows. This System is developed for 4 division of CPI (EIMAC, SATCOM, MPP and TWTP) This System is used to Manage Supplier Quality Information, Receiving, Inspection, Nonconformance and Supplier Rating. This system also features Skip Lot for Certified parts, tracks non conformances, Maintain Disposition, Perform MRB and analyze root Causes. I have also developed MRD and it’s description as follows Material Receipt Document provides the information of receiving and purchasing like quantity received, Quantity due, vendor, stock room details, inspection details, receiving details etc., This document travels with the received material from receiving to stock room.Apart from above mentioned projects, I was also involved in the Data Migration Projects. Responsibilities:

Database administration and development.

Developed ASP pages, created modules using VB etc., My Role: SQL Server DBA, Database Developer, Crystal Report Writer, Software Developer, Web Developer, Q A Engineer

Technologies & Tools Used : MS SQL Server 7.0,DB2, IIS, Oracle, MS Access, VB, VB Script, ASP, Visual InterDev 6.0, Java, Windows NT, UNIX, CINCOM1.4.1.2, E – Merge, PL/SQL, Crystal Reports Zeus Software Systems, Hyderabad, INDIA October 1995 - July 1998 During this time with Zeus Software Systems, I have worked on various projects and the projects are Material Requirement Planning, Sales management system, Personal Information Systems, shares Accounting System and Fleet Management system. 6

My Role: Database Developer & Software Engineer

Technologies Used: Visual Basic 5.0, SYBASE, MS SQL Server 6.5, MS Access Crystal Reports, Windows NT

EDUCATION, TRAINING & CERTIFICATES

Microsoft Certification:

Administering Microsoft SQL Server 2012 databases.

Querying Microsoft SQL Server 2012.

Taken courses in Microsoft Virtual Academy in Admin, Development etc.,

Honors Diploma in Network Centered Computing from NIIT (1 Year)

BS from Osmania University, Hyderabad, India



Contact this candidate