Sql Server Manager
Resume:
MADHUKER RAPOLU
**********@*******.***
402-***-****(ph.no)
PROFESSIONAL SUMMARY:
Over 20 years of IT experience in Database Administration, System Administration and Programming in RDBMS/MS-SQL Server 6.5, 7.0, 2000, 2005, 2008, 2008R2, 2012, 2014, 2016, SSAS, Integration Services, DB2, MySQL, Oracle 9i, 10g, 11g.
Expert in Database Engineering in the architecture, design, development and deployment in SQL Server and Oracle, System Analysis, Database Administration, Cluster Administration, Designing the, Database Design, Tables Design, Writing TSQL Statements, Stored Procedures, Views, Triggers, Creating the Indexes, Creating the New User logins, Roles, Granting Permissions to User logins as needed, Backup, Recovery, Creating and managing SSIS/DTS Package, Jobs. Export, Import, BCP, Archiving Data. Replication, Database Mirroring, Always On, Log Shipping for High Availability. Performance Tuning, Trouble-shooting, Bottleneck Identification, Monitoring Error, Event logs, setting up the SQL Mail, setting the SQL Mail, Upgrading the SQL Server from 6.5, 7.0, 2000, 2005, 2008, 2008R2. Working in large database size of Terabyte. 24/7 Support for Production Databases and Applications, Has excellent Analytical and Programming Skills along with good communication and Interpersonal skills.
I have designed developed deploy and manage large and complex data warehouse databases in SQL Server 2008R2/2012/2014/2016
Good Knowledge of Sybase, Oracle, MS-Access, Terradata, MySQL, Informix, DB2 databases.
EDUCATION: Masters in Computer Management (MCM)
B.S. in Computer Science
Microsoft Certified in SQL Server 2005-MCITP
Microsoft Certified in SQL Server 2008-MCITP
TECHNICAL SKILLS:
Operating Systems : Windows 2000/NT/98/95, Windows Server 2003, UNIX, Linux,
DOS.
RDBMS : SQL Server 6.5/7.0, 2000, 2005, 2008, 2008R2, 2012, 2014
DB2, MySQL, Oracle 8i, Ms-Access, Terradata, Olap Services 2000, 2005.
SQL Clients : Enterprise Manager, Security Manager, Trace, SQL Setup,
Service Manager, Upgrade Wizard, MsAnalysis Manager, Query
Analyzer, Embarcardaro and Cagnos.
ETL Tool : Integration Services, Informatica, Data Stage, DTS.
Languages Packages : Visual Basic 5.0/6.0, Developer /2000, Informatica,
Cobol.
ERP : People soft.
Office : Microsoft Word, Microsoft Excel, and Microsoft PowerPoint,
Visio 2002.
Web Tools : JSP, HTML, DHTML, ASP, Perl, Visual Interdev 5.0, VBScript,
Java script, Front page, IIS 4.0
PROFESSIONAL EXPERIENCE:
Business Ink, Austin, Tx
Nov ‘2013 to Present
Applications are developed in ASP, JSP, .NET for front end and SQL Server 2005/2008/2008R2/2012/2014/2016 and Oracle 10g, 11g at the Server end.
Role : Sr Database Administrator
Hardware : Pentium, Compaq, Dell, Blades
Software : ASP, JSP, .NET, VB Scrip, Java Script, and
MS-SQL Server 2005/2008/2008R2/2012 on Windows 2008/2012. Oracle 10g/11g on Unix Aix, Linux.
As a SQL Server DBA involved in:
Designing logical and physical database design, Administration of Databases and Applications
Installed, Configured and Maintained MS SQL Server, on Physical and Virtual environment
Managing and Maintaining SQL Server in Cluster Environment on Windows 2008/2008R2/2012/2014
Designing, Plan and Create the New Data File, Transaction Log Files and File groups for Databases and Estimate the storage size
Setup manage and maintain High Availability using Clustering, Database Mirroring, Replication, Log Shipping and Always On
Creating Databases, Tables, Indexes, Writing TSQL Statements, Stored Procedures, Views, Triggers in databases as necessary
Creating database logins in Standard, Integrated, Mixed mode and giving them permissions, enforcing policies and maintaining them
Creating Backup Jobs using Maintenance plan on Backup Devices and Tapes
Setting up SQL Mail for Jobs
Importing and Exporting the data across the Databases and Servers using SSIS
Creating the Linked Servers across the SQL Server databases, Oracle.
Performing Optimization for Queries and Stored procedures
Scheduling the Jobs thought SQL Executive, Notification Services and checking daily/weekly jobs and notifying them through Email
Setting up Alerts for Errors/Task completion
Going thought Day to day SQL Server logs, Application logs, Security logs, System logs
Running the Update statistics on the Production, Staging and Development databases
Monitoring the locks
Improving Logical and Physical I/O, Performance Monitoring, Bottleneck identification and trouble-shooting
Upgrading SQL Server from one version to another version and applying patches for each version for sql server and oracle
24/7 Support for Production databases and Applications
Samsung Austin Semiconductors, Austin, TX.
Sep ‘2012 to Nov ‘2013
At Samsung Austin Semiconductors, some of the applications that are used in the fab for monitoring the tools to run the fab, reporting application and all the internal application for time management are built in front end Java and .Net with SQL Server 2005, 2008, 2008R2 and 2012 as back end. SSIS, SSRS as for extract transform load data from various databases to Data Ware house.
Role : Sr. Engineer(Database
Administrator Supporting
around 90+ SQL Server’s)
Sr Engineer Database technologies : MS-SQL Server 2000/2005/2008/2008R2/2012
On Windows 2003/2008/2008R2, SAS, Integration Services, SAS 2005, Oracle 10g, 11g, MySQL, PeopleSoft.
As a SQL Server DBA involved in:
Administration of Databases in Production and development.
Installed, Configured and Maintained MS SQL Server, on Physical and Virtual environment.
Managing and Maintaining the SQL Server in Cluster Environment on Windows 2003/2008R2
Designing, Plan and Create the New Data File, Transaction Log Files and File groups for Databases and Estimate the storage size.
Creating database logins in Standard, Integrated, Mixed mode and giving them permissions, enforcing policies and maintaining them
Creating Databases, Tables, Indexes, Writing TSQL Statements, Stored Procedures, Views, Triggers in databases as necessary.
Creating Backup Jobs using Maintenance plan on Backup Devices and Tapes
Setting up SQL Mail for Jobs
Importing and Exporting the data across the Databases and Servers using Integration Services.
Creating the Linked Servers across the SQL Server databases, Oracle, Sybase
Performing Optimization for Queries and Stored procedures
Using Profiler capturing slow running queries, locks, show plan.
Dynamic management views are used to capture top running queries, CPU, Memory usage, I/O usage.
Scheduling the Jobs thought Management Studio, Notification Services and checking daily/weekly jobs and notifying them through Email
Setting up Alerts for Errors/Task completion
Running the Update statistics on the Production, Staging and Development databases
Running the DBCC checks on the databases, Rebuild Indexes on tables
Improving Logical and Physical I/O, Performance Monitoring, Bottleneck identification and trouble-shooting
Upgrading SQL Server 2000 to 2005, 2008, 2008R2, Migrating DTS Packages to Integration Services.
24/7 Support for Production databases and Applications
Alegent Health, Omaha, NE
July ‘2007 to Sep ‘2012
Alegent Health is Chain of Hospitals and Clinics across Nebraska and Iowa state, All the applications are Client server applications which are developed in Java, .Net, ASP, JSP, .NET for front end and SQL Server 7.0/2000/2005/2008/2008R2 on Server end.
Role :Database Administrator (Supporting around 140+ SQL Server’s)
Database technologies : MS-SQL Server 2000/2005/2008/2008R2 on
Windows 2003/2008/2008R2, SAS, Integration Services, SAS 2005, Oracle 10g, 11g, MySQL, PeopleSoft.
As a SQL Server DBA involved in:
Administration of Databases and Applications
Installed, Configured and Maintained MS SQL Server, on Physical and Virtual environment, Management Studio, Visual studio, SQL Setup and Performance Monitor
Managing and Maintaining the SQL Server in Cluster Environment on Windows 2003/2008R2
Designing, Plan and Create the New Data File, Transaction Log Files and File groups for Databases and Estimate the storage size.
Creating Databases, Tables, Indexes, Writing TSQL Statements, Stored Procedures, Views, Triggers in databases as necessary
Creating database logins in Standard, Integrated, Mixed mode and giving them permissions, enforcing policies and maintaining them
Creating Backup Jobs using Maintenance plan on Backup Devices and Tapes
Setting up SQL Mail for Jobs
Importing and exporting the data across the Databases and Servers using Integration Services.
Creating the Linked Servers across the SQL Server databases, Oracle, Sybase
Performing Optimization for Queries and Stored procedures
Using Profiler capturing slow running queries, locks, show plan.
Dynamic management views are used to capture top running queries, CPU, Memory usage, I/O usage.
Scheduling the Jobs thought Management Studio, Notification Services and checking daily/weekly jobs and notifying them through Email
Setting up Alerts for Errors/Task completion
Running the Update statistics on the Production, Staging and Development databases
Running the DBCC checks on the databases, Rebuild Indexes on tables
Improving Logical and Physical I/O, Performance Monitoring, Bottleneck identification and trouble-shooting
Upgrading SQL Server 2000 to 2005, 2008, 2008R2, Migrating DTS Packages to Integration Services.
24/7 Support for Production databases and Applications
Ace Technologies Inc.,
Aug’ 1999 to June’ 2007
Client: - GE Transportation System, MO
Different Application are developed for the GE Transportation System, using .NET, VB, ASP, JSP for Application end and SQL Server 6.5, 7.0, 2000, OLAP Services 2000, Oracle 8i as the Server end, to provide the information for all the Sales, Accounting, Payroll, Labor, Parts for Monthly, Quarterly and Year end reports. There is a Datawarehouse database on SQL Server 2000 Clustering, which provides the information for Parts, Labor, and auctions for Locomotives to all the end user.
Role : MS-SQL Server System Administrator, DBA and SAS Analyst.
Hardware : Pentium, Dell
Environment : SQL Server 6.5/7.0/2000/2005
Software : JSP, HTML, MS Analysis Services, Cagnos, Informatica,
MS-SQL Server 6.5/7.0/2000 Windows NT 4.0, Windows 2000 and Windows 2003, 2000 MS-Access, Oracle 8i on Unix, Mainframes
As a SQL Server DBA involved in:
Involved in Resource Planning for MS SQL Server Installation.
Installed, Configured and Maintained MS SQL Server, SQL Executive, Enterprise Manager, Transfer Manager, Server Manager, SQL Setup and Performance Monitor.
Designing, Administrating and Maintaining the SQL Server Databases and Microsoft OLAP Cube databases in Production, Staging, Development Environments
Managing and Maintaining the SQL Server in Cluster Environment on Windows 2000/2003
Involved in Designing, Development, Testing, Debugging and Documentation for different Applications and Databases
Designing, Plan and Create the New Data File, Transaction Log Files and File groups for Databases and Estimate the storage size
Create the new Tables, Indexes
Writing TSQL Statements, Stored Procedures, Views and Triggers
Perform Optimization and Tuning the queries
Creating the New Users, Roles and Grant Permissions and maintaining them
Grant permissions to Tables, Stored Procedures, Views
Taking Database Backups and Transaction logs backups everyday, Disaster recovery plan
Monitoring day to day activities like checking disk space, SQL Server Error Logs, Database dumps, Transaction Dumps and Running database consistency checks
Monitoring locks and usage of CPU
Using Data Transformation Services create the DTS Packages
Import and Export data, writing BCP scripts for transferring data across different servers and databases
Setting up the Replication for tables across different Servers
Creating and Maintain the log shipping to Fault tolerance server
Improving Logical and Physical I/O, Performance Monitoring, Bottleneck identification and trouble-shooting
Monitoring SQL Server Logs, Application logs, Security logs, System logs
Setting up Alerts for different event and solving the issues when it send Alerts
Creating and Managing the SQL Server Jobs, setting up the Operators to send Emails
Creating the remote Linked servers, connecting to Oracle, Mainframes, DB2 databases
Setting up SQL Mail
Designing and developing the Olap Database, Cubes and support them
Creating the DTS Packages for the Cubes to refresh and schedule them
Setting up the Jobs using third party tools like Appworx and Informatica
Creating and Maintain the log shipping to Fault tolerance server
Diagnosing system problems
Upgrade SQL Server 6.5, 7.0 to 2000
Migrating SQL Server 7.0 and 2000 to Cluster Servers
24/7 Support for Production databases and Applications
Jan '1996 - July '1999
Sigma systems.
Accounting Interface Application designer/programmer Using Visual Basic 5.0, Crystal reports 5.0, SQL Server 7.0, Transact SQL, Windows 95
Contact this candidate