Sql Server Manager
Resume:
Rajesh Muppoor
Monroe, New Jersey 08831
609-***-**** or *************@*****.***
PROFESSIONAL SUMMARY:
. 9+ years of IT experience in Design, Development and Support of MS SQL
Server 2000 2005, 2008 & 2012 in Production, Testing, and
Development.
. Experience in Migration from SQL Server 2000 to SQL Server 2005.
. Have good experience in an operation environment providing support
involving coordination with release management and change management.
. Expertise in planning and implementing MSSQL server Security.
. Have experience in Planning and implementing Replication and Log
Shipping.
. Extensive experience in MS-SQL Server Administration including Design
and implementation of Replicated Databases, planning and implementing
of Backup, Restore Strategies and Recovery procedures.
. Good experience in Query Optimization, Tuning Stored Procedures, and
Performance Tuning. Creating and managing Indexes, Database
Consistency Checks using DBCC Utilities.
. Developed backup and recovery strategies for production environment.
Also documented disaster recovery plans and participated disaster
recovery drills.
. Expert level skills in Extraction, Transformation and Loading using
different tools like DTS packages and SSIS in SQL Server databases.
. Generated different reports using MS SQL Reporting Services(SSRS)
. Self-motivated, Good team player, with effective communication and
Leadership qualities.
Technical Skills:
Relational Databases : SQL Server 7.0/2000/2005/2008/2012, MySQL, Oracle,
MS Access.
Operating Systems : Windows OS Series, UNIX, Linux.
Languages : T-SQL, PL-SQL, HTML, JAVA SCRIPT, ASP.NET,
COBOL.
Source Control : Visual Source Safe 6.0
SQL Tools : Management Studio, Enterprise Manager,
Profiler, DTS, Job Scheduler
BI Tools : SSIS, SSRS.
Third Party Tools : Toad for SQL Server, MQSeries, Crystal Reports
Professional Experience:
Blue Sky MLS, Inc. - Parsippany, NJ
June 2001 to Present
SQL Developer
Description: Blue Sky MLS is a compliance provider for the securities
industry. The company specializes in regulatory compliance for Mutual
Funds, Private Offerings, Broker Dealer, and Investment advisors. Services
are provided either on an outsourcing basis or through system leasing.
Services are highly automated through web-based applications.
Responsibilities:
. Experience in Migration from SQL Server 2000 to 2005.
. Creating databases and logins with permissions in SQL Server 2000,
2005, 2008 & 2012
. Created and monitored Database maintenance plans for checking database
integrity, data optimization, rebuilding indexes, and updating
statistics.
. Migrated DTS packages and converted them to SSIS packages in SQL
Server 2005.
. Created ETL Transformations to copy columns and load data between
source and destination databases.
. Developed SSRS reports in Reporting Services to produce custom reports
for DSS (Decision Support System) databases.
. Used some performance monitoring tools like SQL Profiler, SQLDiag,
Blocker Script, and System Monitor.
. Database version control using VSS.
. Taking Daily Database backups .
. Testing Database backups once in a week on Testing Server.
. Running DBCC and ReIndexing Databases on weekly basis
. Managing and scheduling daily jobs relating to data transfers, backup
and recovery, transaction log dumps.
. Created and modified stored procedures, triggers, views, and indexes
to provide best performance.
. Restore Development and Staging databases from production backups as
per the requirement.
. Involved in resolving blocking, dead lock issues, and performance
issues.
. Coordinating with the development team regarding tuning the SQL
queries and stored procedures.
. Identifying the bottlenecks and troubleshooting them for optimal
performance.
. Documentation of daily tasks.
Environment: MS SQL Server 2000/2005/2008/2012, Windows 2000/2003 servers,
Visual Source Safe 6.0,Outlook Express, Toad for SQL Server, LiteSpeed.
American International Group - New York, NY
November 2000 to May 2001
SQL Developer
Description: AIWCS is a policy underwriting system for worker's
compensation. Workers compensation is a body of laws designed to provide
satisfactory means of handling occupational injuries and disabilities
without regards to fault. This project being a Re-Engineering Project is
designed to replace Workers Compensation Personnel Computing (WCPC) System,
which can perform all new or renewal business rating, quoting and issuing
of policies by a Java based GUI.
Responsibilities:
. Installed, configured, administered, and secured SQL Server 2000/7.0
on Server and Clients.
. Designed, implemented, and administrated databases in SQL Server 2000.
. Managed Logins, Users, Roles and User permissions, and conducted
backup and recovery.
. Developed administrative tasks of SQL Server of performing daily
Backups and recovery procedures.
. Created alerts and notifications for system errors, insufficient
resources, and fatal database errors.
. Created DTS package to export and import data from SQL Server to
Access, text and EXCEL files.
. Configured Log shipping from one production server to the reporting
server.
. Maintained Operators, Alert Notifications, Jobs, Job Steps, and
Schedules.
. Monitored connections, locks, and performance of SQL server.
. Scheduled and monitored all maintenance activities including database
consistency check, index defragmentation.
. Used SQL Profiler for troubleshooting, monitoring, tuning of SQL
Server and SQL code
. Developed stored procedures, advanced queries, trigger, views, and
indexes by using T- SQL.
Environment: SQL Server 7/2000, Windows 2K/NT, SQL Profiler, DTS, T-SQL,
BCP, Replication, Enterprise Manager.
QWEST - Denver, CO
January 1999 to September 2000
SQL Server DBA/ Developer
Description: Customer Billing Inquiry project is to develop a graphical
user interface system that allows Customer Service Representatives (CSR) to
more easily and effectively get to customer billing information, which in
turn provides improved service to customers. Using the CBI, a CSR will be
able to review billing and payment information, review account adjustments,
update credit information, review, and submit account notations. The CBI
user interface application provides friendly windows environment tailored
to maximize productivity and effectiveness in assisting customers.
Responsibilities:
. Installation of SQL server on Development and Production Servers,
setting up databases, users, roles, and permissions.
. Imported Data from text files and excel spread sheet into SQL Server
2000 database using DTS package.
. Involved in migration from SQL 7.0 to SQL2000.
. Performing the ETL operations to support the data loads an
Transformations.
. Implemented automated backup and database maintenance / cleanup jobs
. Managing Logins, Users, Roles and User permissions.
. Running Trace from the Profiler to trouble shoot database and running
DBCC consistency checks for other database maintenance aspects.
. Set up SQL Mail and Created Jobs to Automate & Scheduled many tasks
. Had good experience in 24/7-production support.
Environment: MS SQL Server 2000, Windows 2000, Windows NT 4.0,
Enterprise Manager, SQL Query Analyzer, SQL
QWEST - Denver, CO
February 1998 to January 1999
Programmer
Description: Central Customer Record Information System (CCRIS) is a
billing system for Central Region of US West. This system is a subsystem
of Central Billing Operations, caters to the Telecommunication Billing
Services. This would include Billing Computation and Assembly, Cash
Payments, Adjustments & Journals and Miscellaneous Carrier Application
System
Responsibilities:
. Preparing Program Specifications
. Coding bridge programs for Interfaces.
. Testing of Online screens.
. Preparing and Reviewing the Test plan.
. Modifying and testing the Production Jobs.
. Implementation and Post-Implementation Support.
. Formatting Messages using NEON software
. Fixing Production problems.
Environment: MQ SERIES, DB2, JAVA SCRIPT, COBOL, HTML
Awards:
. Received from QWEST, a Certificate of Achievement in recognition &
Appreciation of my contribution in earning the SEI CMM LEVEL 5.
. Received from QWEST, a Certificate of Achievement in recognition &
Appreciation of my contributions to the performance of CBI project.
Education: Masters in Engineering
Contact this candidate