SQL DBA/Developer
Resume:
VENU B
*******@*****.***
SUMMARY
Around 8 years of technical experience in Production Support and Database Administration, Business Intelligence including design, development and implementation of Microsoft SQL Server 2008, 2005 and 2000.
Extensive experience in all DBA activities such as installation, Database design, development, Administration, user management (SQL Server and Active Directory) and maintenance of SQL Server 2000, 2005 and 2008 Databases.
Experience in developing, maintaining, scheduling and monitoring SSIS and DTS Packages.
Worked with performance tools like SQL Profiler, Database Tuning Wizard and Windows Performance Monitor for monitoring and tuning MS SQL Server database as well as performance.
Creating scripts with DBCC, DML commands as part of maintenance activities of SQL Server.
Very good experience in migrating from Mainframe DB2 to SQL Server. Also good experience in converting COBOL+DB2 business logic into SQL Stored Procedures.
Hands on Experience in installing, maintaining, configuring, managing, monitoring and troubleshooting SQL Server 2005.
Extensive experience in T-SQL in creating triggers, tables, user functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity.
Good understanding in implementing different types of Replication Models such as Transactional, Snapshot and Merge.
Very good experience in configuring and monitoring Replication, Clustering, Database mirroring and Log shipping.
Hands-on experience in performance tuning, log file monitoring, updates statistics, Re-indexing, Re-organizing, executing DBCC commands, backup and recovery of SQL server databases on Windows 2000/2003 and Windows-NT.
Creating and executing several onetime Scripts, UNIX Sell scripting as and when required.
Experience in extracting and transforming data using DTS Import/Export Data, Bulk Insert, BCP and DTS Packages.
Experienced in setting up SQL Jobs, Operators, Alerts, Notifications, Database and SQL Mail Profile. Used Autosys for scheduling the jobs.
Used different type of third party tolls like Red-Gate, SQL Compare and Idera according to the requirement.
Very good experience in network side such as configuring routers and creating VPN tunnels.
Very good working experience in development and administration of SSRS reports.
TECHNICAL SKILLS
Operating Systems Windows 9x/NT/2000/XP/Vista, Windows
2000/2003 Servers R2
BI Tools SSRS 2000/2005, SSIS, BO XI R2
Application Packages SQL Enterprise Manager, SQL Profiler, SQL
Query Analyzer, Index Analyzer, DTS,
Import/Export, SQL Client Configuration
Utility, SQL Server Management Studio,
SSIS,SQL Server Business Intelligence
Development Studio, MS Visual Studio
2003/2005, MS office Suite
Databases MS SQL Server 2000/2005/2008, MS Access,
Oracle 9i/10g, DB2 V8 and Teradata.
Tools Autosys, DTS, LiteSpeed, VMWare, Red-Gate,
Idera, SQL Compare, SQL Merge
Languages C, JSP, Servlets, SQL, Transact SQL (T-SQL),
COBOL, HTML, C#.Net and VB.Net
MICROSOFT CERTIFICATION
Completed Microsoft certification – Implementation and Maintenance of SQL Server
PROFESSIONAL EXPERIENCE
Kaplan Eduneering, Princeton, NJ Oct ’09 – Till Date MS SQL Developer/DBA
Kaplan Eduneering ComplianceWire is a fully validated learning management system. As part of the 2009 Release 2 they are restructuring their database for the new features and efficient management of the E-Learning management system.
Responsibilities:
• Involved in the analysis of existing stored procedures, Database tables, views, User defined functions and triggers.
• Involved in the analysis of existing database structures and creating the new tables and views as per the new requirements.
• Involved in changing the stored procedures, user defined functions to use new tables and new columns.
• Involved in preparing the unit test plan and testing the stored procedures.
• Tuning the existing the stored procedures for the better performance and suggesting the indexes in the required tables.
• Involved in the system testing, regression testing.
• Involved in the changes in the front end C# according to the new database structure.
• Involved in Self-review and peer-review of the codes and unit test results.
• Involved in Performance tuning of T-SQL SPs, Triggers and also involved in the process of identifying the missing indexes and usage of existing indexes.
• Also involved in writing scripts as part of maintenance tasks like update stats.
• Involved in all phases of software development life cycle from Requirements, Analysis, Coding, Code Reviews, Unit Testing, Test Results review and Production support life cycle (Change Controls)
• Involved in the modifications to DTS packages/SSIS packages according to the new database structure. Also involved in the tables design.
Environment: MS SQL Server 2000, ASP.NET, T-SQL, DTS, Windows 2003 Server R2, SQL profiler, Query Analyzer, SSMS, SQLCMD, OSQL, SQL Server Compare Tool, VSS 6.0d, Win Merge Tool, Office XP, Idera Tools, RedGate Tools.
MDTablet Support, AMDC, Edison, NJ Oct ’08 – Sep ‘09 MS SQL Server DBA
MDTablet is EMR Digital Healthcare product for Physicians where in the Doctors manage their
Patients’ visits, insurance, Chief Complaints, medication and Drugs database.
Responsibilities:
• Worked as a Production support DBA. Involved in right from the new installations till the support of SQL Server 2000 and SQL Server 2008.
• Configuring Merge replication between the server and the client machines. Resolving the issues on the merge replication.
• Created a process which alerts the users if the replication is not happening for the past 15 days via e-mail.
• Creating databases with TDE security and also encrypting the data at column level.
• Developed interfaces Lytec and Constantinou to pull the data from third party EMR tools to MDTablet.
• Troubleshooting the server for the performance and memory utilization.
• Creating users and assigning permissions to them.
• Taking the backups according to the developer’s req uirements and restoring them on the databases.
• Changing the existing stored procedures for the better performance by changing the DDL, DML and DRL queries.
• Replacing the VBScript functionality with appropriate task in SSIS while migrating DTS packages.
• Moving the system database from SAN to local drives and local drives to SAN as part of disk maintenance.
• Worked on VB.Net (Windows App) and C#.Net (Web Application) for developing the utilities such as Server Manager, Patient Merger, Visit Re open, Open Door and Hide Visit.
• Configuring Clustering, Log shipping and Merge Replication at SQL Server level and monitoring.
• Creating database Maintenance plans using SSIS and DTS packages.
• Creating test environments for the developers to test the new builds.
• Creating the new databases and applying scripts to the databases for every new build that come up and making the application available to the users on Citrix.
• Configuring the Primary VPN tunnel and Failover VPN tunnel between the client and the server and also involved in configuring the switches.
• Collecting the hop count and other statistics for the network analysis.
• Running the SQL Profiler for troubleshooting the application issues for the database errors.
• Created script for uploading the images to the SQL Server using the utility called Text copy.
• Creating snap shots and pushing the replication to the clients on regular basis.
• Configuring log shipping for the primary server and standby server.
• Involved in migration of servers from 2000 to 2008.
• Good experience in configuring SharePoint and integrating SSRS reports into SharePoint.
• Creating Audits at database level as well as at the server level.
• Configuring Citrix Access Gateway and assigning static Ips for all the users and publishing the applications.
Environment: MS SQL Server 2008, Oracle 10g, MS SQL Server 2000,Networker, T-SQL, DTS, SSIS, VMWare, VB.NET, Windows 2003 Server R2,SSRS, VBScript, SQL profiler, Query Analyzer, SQLCMD, OSQL, SQL Server Compare Tool, Red Gate SQL Tool belt, SQL Server Management Studio.
Payless Shoe Source Inc, Topeka, KS Feb ‘06 – Sep ‘08
MS SQL Server DBA/Mainframe DB2 Analyst
Payless is the largest specialty family footwear retailer in the Western Hemisphere. It is operating business around 11 countries including US and the corporate head quarter is located at Topeka, Kansas. The Project scope includes migration from Mainframe DB2 to SQL Server 2005, enterprise database administration, development, maintenance and production support for Payless databases.
Responsibilities:
• Performed server installation and configuration for SQL Server 2005 and SQL Server 2008.
• Performed installation and up gradation of SQL Server Service Packs.
• Preparing SQL Server and creating partition tables to hold the millions of rows from DB2 to SQL Server.
• Scheduled Full and Transactional log backups for the user created and system databases in the production environment using the Database Maintenance Plan Wizard.
• Setup backup and restoration jobs for development and QA environments when necessary.
• Configured Transactional Replication with SQL Server Management Studio as well as basic account management and troubleshooting with connectivity, security and firewall issues.
• Involved in developing a number of stored procedures, triggers and views using SQL Server 2005.
• Configuring linked servers for remote data access from DB2, Oracle, MS Access and other SQL Servers.
• Involved in analyzing COBOL, DB2 programs into SQL SPs and triggers.
• Migration of data from Mainframe DB2 to Flat files to SQL Server using SSIS packages.
• Implemented partitioning to handle tables with over 300 million rows.
• Configured merge replication for the servers located at different countries and the central server located at Topeka.
• Configuring, monitoring and troubleshooting High availability solutions Clustering, replication and Disaster recovery solutions.
• Implementing Security strategies as per the requirements and also involved in the creation of certificates as part of Database mirroring.
• Setup Database Maintenance Plans to reorganize indexes, re-indexing and update the index statistics on the production databases.
• Used SQL Server Profiler to monitor and record database activities of particular users and applications.
• Used DBCC commands to troubleshoot issues related to database consistency.
• Fine tuned Stored Procedures using Execution Plan in T-SQL for better performance.
• Configuring mirroring for the sales databases and configuring log shipping for the reporting databases.
• Identified the data sources and created new datasets to design the queries for the report generation.
• Exporting/Importing the data between the SQL Server and DB2 databases using SSIS packages.
Environment: MS SQL Server 2008, MS SQL Server 2005, DB2 V8, Networker, Autosys, T-SQL, DTS, VMWare, LiteSpeed, Windows 2003 Server, SSIS, SSRS, SQL profiler, Teradata V2R5.
Kraft Foods, Winnetka, Illinois Feb ‘05 – Jan ‘06
SQL Server DBA/ Developer
Responsibilities:
• Development & Database Maintenance of SQL Server on Windows 2000 server.
• Providing database administration support to 24x7 high availability environments.
• Performed DBA activities like administering and maintaining the database, Partitioning, Indexing large Databases, space management, database tuning, database backup & recovery.
• Used DTS, BCP, DBCC and SQL-Profiler extensively.
• Created the linked servers for the remote data access from other SQL Servers, MS Access.
• Planned and tested processes for both backup and recovery.
• Managing Replication databases and fixing the errors when they arise.
• Generating SQL 2000 migration scripts and reediting the stored procedures from SQL 7.0, to be compatible with SQL 2000.
• Involved in Configuring high availability solutions Active/Active Clustering, Active/Passive Clustering, monitoring and troubleshooting.
• Running DBCC consistency checks, and fixing data corruption in application databases.
• Basic NT Administration assisting the Senior Network Administrator.
• Performed Diagnosis & Tuned database and SQL statements as and when required.
• Involved different Data Warehouse techniques like Star-Schema and Snow-Flake schema.
• Implemented SQL/TSQL Stored Procedures/Functions.
• Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine
tuning Advisor.
• Troubleshoot system issues, monitored scheduled jobs and set up maintenance plans for
Proactively monitoring the performance of SQL Server databases.
• Performance Tuning & Optimization: Regularly evaluate and monitor databases and stored
Procedures to identify and resolve performance and reliability issues.
Monitored performance and optimize SQL queries for maximum efficiency.
Environment: MS SQL Server 2000 Enterprise Manager, Windows 2003 Advanced Server, SQL Profiler, DTS, T-SQL, UNIX, Autosys, LiteSpeed, MS-ACCESS 2000.
Aetna Insurance, Middletown, CT Jan ‘04 – Feb ‘05
SQL Server DBA/ SSRS Developer
Aetna Insurance is one of the country’s leading diversified health care benefits company offering a wide range of health insurance products and services including medical, pharmacy, dental, behavioral health, group life, long term plans and disability plans with medical management capabilities. The project involved developing sales reports and statistics to cover weekly, monthly, quarterly, and annual historical information for the Sales department.
Responsibilities:
• Actively supported business users for given requirements.
• Managed the migration of SQL Server 2000 databases to SQL Server 2005
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL
• Designed report layouts that suits for the business rules.
• Identified and defined the Datasets for report generation.
• Developed queries for drill down reports.
• Developed reusable reports by passing Parameters based on business needs
• Formatted the reports using Global variables and expressions.
• Deployed the generated reports on to the Report Server.
• Configured merge replication and Active/Active clustering.
• Defined attribute properties in a Parent Child Dimensions.
• Developed reports using attributes hierarchies with hiding and disabling.
• Maintained data integrity by performing validation checks.
• Optimized queries, tuned, and monitored server performance, written T- SQL queries for
Data retrieval.
• Fine-tuned the database objects and server to ensure efficient data retrieval.
Environment: MS SQL Server 2000, BO XI R2, MS SQL Server Reporting Services 2000,
Windows 2003 Server, T-SQL, Networker, RedGate Tools.
Target Corporation, Minnesota, MN Jun ‘02 – Jan ‘04
MS SQL DBA
Involved in a system developed for the client Target to track the sales, purchase and material inventory, sales, inventory & financial subsystems development. Counter sales maintenance, daily cash & bank reconciliation.
Responsibilities:
• Involved in the entire System study, analysis and design.
• Involved in the creation of schema objects like indexes, views, stored procedures and synonyms.
• Pumping the data into Mainframe DB2 via the DTS.
• Involved in the analysis of how the purchase order process was organized.
• Created SQL tables with referential integrity and developed queries using SQL.
• Involved in writing Stored Procedures which internally calls functions.
• Involved in testing the database for queries that were generated and handled the performance issues effectively.
• Monitoring and configuring Clustering, log shipping and database mirroring.
• Involved in documenting the entire technical process.
• Supported technical teams involved with MS SQL issues and operations.
• Involved in the maintenance of the database.
Environment: MS SQL 2000, Windows NT, DTS, T-SQL, C#.Net, Core Java
EDUCATION
• Bachelor of Technology from Mahatma Gandhi Institute of Technology, JNTU, India.
Contact this candidate