KASI PRAMOD

Ph: 814-***-**** email: ch757k@r.postjobfree.com

SUMMARY:

• Over 8 years of technical experience in Production Support and Database Administration using Microsoft SQL Server7.0, 2000, 2005, 2008 and 2008R2.

• Experience in bringing all versions of SQL servers to meet the DISA standards and making them compliant.

• Extensive experience in User maintenance in SQL and in Security Expressions.

• Extensive experience in MS SQL Server fail over clustering, Log shipping, Database Mirroring and Replication.

• Handled Logical Data and Index partitioning for large tables in SQL Server 2005 and 2008.

• Proven ability to handle Database of more than 1 TB in Size.

• Conducted root cause and analysis for database incidents and problems.

• Experienced in T-SQL, SQL* Plus. Developed and optimized stored procedures, triggers, functions, cursors and ETL packages.

• Experienced with Windows system administration.

• Basic knowledge of TCP\IP network troubleshooting.

• Modified & created Indexes, Optimizing Indexes.

• Migrated data from various sources such as MS Access, flat files etc.

• Proficient in using WMI (Windows Management Instrumentation) and able to manipulate WMI queries and made it work as per the environment standards.

• Experienced in creating and maintaining SSIS packages, created reports using SSRS.

• Extensive Knowledge on LDAP.

• Extensive experience in monitoring SQL Server Databases.

• Good working knowledge on monitoring tools like Microsoft Systems Center Operations Manager (SCOM) and Microsoft Operations Manager (MOM).

• Working experience on Data Warehousing and Business Intelligence.

• Extensive Knowledge on Claims processing which are processed from Mainframes.

• Experience in creating and maintaining Disaster recovery processes.

• Experience in extracting and transforming data using DTS Import Export Data, Bulk Insert, BCP and DTS Packages, configuring XML support in IIS.

• Hands-on experience in performance tuning, backup and recovery of SQL server databases.

• Extensive experience in creating functional and technical documentation.

• Experience in Healthcare, Financial, Automobile and Communication Industries.

• Experience in logical and physical data modeling using Erwin.

• Experienced in setting up SQL Jobs, Operators, Alerts and Mail Profile.

• Excellent managerial, communication and interpersonal skills.

• Ensured databases are secured and SOX complaint.

• Experienced using Microsoft Visio, Microsoft Project 2003.

• Posses strong analytical and Project Management Skills, Good Leadership skills and Communication skills.

• Proven analytical abilities with attention to detail and ability to work effectively in a fast paced environment.

EDUCATION:

Bachelor of Technology (Mechanical Engineering).

TECHNICAL SKILLS:

DBMS: MS SQL Server 2008, 2005, 2000, 7.0, Oracle and MS Access.

Hardware: IBM Compatible computers and Apple Mac

Operating Systems: Windows NT, 2000, 2003 servers, windows 98, XP, Windows 2000 workstation, MS-DOS.

Languages: VB 6.0, C++, HTML and Java Script

Application: MS Office, MS Project, Visio, Visual source safe

Tools: Security Expressions, Erwin, SQL Cluster, Performance Monitor, SQL Profiler, SQL Query Analyzer, ISQL, OSQL, NetIQ, Cluster Administrator, Remedy, Repliweb.

Professional Experience:

DMEAutomotive May2010 to Present.

As a fully integrated direct marketing company, DME Holdings, LLC is continually pushing the limits of technology to provide their clients with the most advanced, data-driven marketing solutions available.

Role: SQL Database Administrator\Developer

Responsibilities.

• Installed and configured SQL Server 2008 R2 on Windows 2008 servers.

• Worked on both 32bit and 64bit windows Operating Systems.

• Performed database/infrastructure physical design, database upgrades & applied software patches to databases as per application/client requirements.

• Implemented & managed database clustering, failover and load balance technologies as per client requirement.

• Created Partitions for very large tables (row level and page level). Experienced with creating and maintaining file groups.

• Upgraded databases from SQL Server 2005 to 2008 by finding deprecated commands (features).

• Suggested, developed & implemented Scaling out solution with Data partitioning.

• Created SSIS packages for the whole ETL process. It is used for Data ware house applications.

• Administered Team Foundation server 2008 and 2010 for source code and deployments standards, familiar with features like merging, data compare.

• Implemented Transactional and Merge Replication in SQL server 2008R2.

• Created the maintenance plans for optimization and integrity check.

• Used Red Gate for backups and Restore and also used extensively for data comparisons between two databases.

• Implemented database replication strategies for DR.

• Experienced in creating SQL JOBS and scheduling and set alerts.

• Active directory administration includes users and group creation in a multi domain environment.

• Also gave Desktop support to the client services when necessary.

• Build new work stations for new hire and took care of the company policy requirements by making the system standards.

• Experienced with point in time restore (PIT) procedures to restore production databases.

• Created SSIS and DTS packages for data manipulation and perform business information.

• Experienced with improving SQL Server performance using performance monitor, index tuning wizards, SQL Profiler, Data base Engine tuning Advisor (DTA) and execution plans.

• Built SQL Server 2008 in windows 2008 server Clustered environment.

• Created and maintained database ERD diagrams.

• Experienced in windows security policies, User Access Control.

• Experienced in monitoring Jobs and trouble shooting them.

• Experienced in tuning Stored Procedures, Index tuning.

• Experienced in creating user defined roles and granting privileges to the database and database objects.

• Experienced in Database Security and creating user groups, granting the roles and permission were granted through Windows AD group.

• Troubleshooting of TCP\IP networks.

Bank Of America Jacksonville FL Jan 2010 to May2010

Bank of America Merrill Lynch powers the complete spectrum of business and commerce throughout the U.S. and Canada. They advise and deliver for clients with the knowledge, strength, relationships and resources of one of the world’s largest financial institutions.

Role: Database Administrator

Responsibilities:

• Installed and configured SQL Server 2008 and 2005 on Windows 2003 server and Windows 2008 Server, applied service packs and cumulative package1 released from Microsoft.

• Migrated databases from SQL Server 2005 to 2008 depending upon the requirement and the applications that support the versions.

• Mainly it is Data center migration project, which involved Terabytes of database in size.

• Installed and configured SQL Servers 2008 in clustered environment.

• Experienced with transactional and merge Replication in SQL server 2008.

• Configured Replication and Database Mirroring in Sql server 2008.

• Familiar with Row level and Page level compression in database.

• Implemented Filtered indexes in SQL server 2008R2.

• A lot of exposure to SQL Server Clustering SQL server 2008.

• 24/7 support on call.

• Used WMI to connect to a remote server and start and stop services.

• Developed scripts in WMI for SQL operations like starting and stopping SQL Server.

• Used third party tools Lite Speed to take backups and also implemented log shipping.

• Upgraded SQL Server 2005 to SQL server 2008.

• Created SSIS packages for XML data import into SQL.

• Configured Log Shipping in many SQL Servers.

Citi Group Sioux Falls, SD June 2009 to December2009

Citibank is one of the largest full service banks in the world offering an unparalleled range of products and services.

Role: Database Administrator\Security Admin

Responsibilities:

• Installed and configured SQL Server 2008 and 2005 on Windows 2003 server, applied service packs and cumulative package1 released from Microsoft.

• Migrated databases from SQL Server 2000 to 2008, 2000 to 2005 and 2005 to 2008 depending upon the requirement and the applications that support the versions.

• Upgraded SQL Server 2005 to SQL server 2008.

• Created SSIS packages for XML data import into SQL.

• Configured Log Shipping in many SQL Servers.

• Testing and analysis of Windows 2008 as per Citi Environment.

• Good working experience in Windows Clustered Environment.

• Installed and configured SQL Servers in clustered environment.

• Experienced with transactional and merge Replication in SQL server 2008.

• Created the maintenance plans for optimization and integrity check.

• Experienced in creating SQL JOBS and scheduling and set alerts.

• Active directory administration includes users and group creation in a multi domain environment.

• Experienced with point in time restore procedures to restore production databases.

• Created SSIS and DTS packages for data manipulation and perform business information.

• Experienced with improving SQL Server performance using performance monitor, index tuning wizards, SQL Profiler and execution plans.

• Experienced in monitoring Jobs and trouble shooting them.

• Experienced in tuning Stored Procedures, Index tuning.

• Experienced in creating user defined roles and granting privileges to the database and database objects.

• Experienced in Database Security and creating user groups, granting the roles and permission were granted through Windows AD group.

• Troubleshooting of TCP\IP networks.

National Government Services, Indianapolis IN: April 2008 to May2009

Well point is a health Benefits Company engaged in providing managed care and health insurance products. NGS is a subsidiary of wellpoint which focuses on Medicare contracts across several regions in United States.

Role: Database Administrator\Developer

Responsibilities:

• Installed SQL Server 2005 on Windows 2003 server, applied service packs and cumulative package1 released from Microsoft.

• Worked on Security Expressions for DISA Project and developed VB scripts to get SQL Servers to DISA Standards and using it as a baseline for all versions of SQL Server there by making the servers DISA Compliance.

• Worked with the Security team for the Windows servers to manage and support and make it compliance and Adhere to the DISA Standards for Auditing.

• Experienced with Windows Performance Monitor to observe the load on the server.

• Extensive Experience with SQL server Security (Access management).

• Experience in setting up Database Mail.

• Experience in giving Production support to the SQL Severs.

• Extensive Experience with SQL server Security.

• Experience in providing user permissions at Server level, Database level and Table Level.

• Experience in SSIS and SSRS.

• Experience in monitoring several In-house applications by using several Virtual Machines. In-house applications which are used in processing Medicare claims.

• Experienced in giving Training on in house applications.

• Experience in changing ODBC connections on the virtual machines and scheduling Jobs on the Windows Virtual Machines.

• Monitored Database activities of particular users and applications using SQL Profiler.

FUJITSU, Lisle, IL Mar 2008 to April 2008

Role: Database Administrator

Consulting services and solutions, Business platform technology, application development tools, storage management, quality of service monitoring, point-of-sale (POS) hardware and software, wireless/mobile devices, Software-as-a-Service ERP solutions for Small to Midsize Manufacturers. Project is all about to migration of the database from ConAgra foods to Armour-Eckrich for generating reports.

Responsibilities:

• Installed SQL Server 2000 on Windows NT server, applied service packs and security fixes.

• Experienced with Server tuning using Windows performance monitor.

• Installed multiple instances of SQL Server for development purpose.

• Worked with the PINC systems front end application.

• Experienced with the snapshot replication.

• Maintained Production server with the maximum availability.

• Experienced with creating DTS packages that performs extracts, data load tasks, movement of databases from development servers to production servers.

• Experienced with moving SQL server 7.0 database to a new server with BACKUP and RESTORE.

• Created DTS packages to import and export the data in and out of SQL Servers to text files.

• Involved in working with LAN Team on Active Directory.

Environment: MS SQL Server 2000, MS SQL Server7.0, T-SQL, DTS, Windows NT Server, SQL profiler, PINC.

American Express, NY Oct 2006 to Jan2008

Role: SQL Server DBA

American Express is a global financial services company which operates in over 30 countries in

Industries including credit cards, prepaid services, merchant services, and travel services.

Responsibilities:

• Installed SQL Server 2000 on windows 2000, 2003 servers, applied service packs and security fixes.

• Experienced with creating logical and physical database design using Erwin tool.

• Experienced with transactional and merge replication.

• Experience in SSAS, creating Cubes and deploying them into a large number of Production servers.

• Created the strategy for backups and restoration procedures and implemented them.

• Experienced with disaster recovery procedures for SQL Servers.

• Configured Log shipping for 2 production projects.

• Created the maintenance plans for optimization and integrity check.

• Experienced with point in time restore procedures to restore production databases.

• Created the DTS packages for data manipulation and perform business information.

• Experienced with Server tuning using Windows performance monitor.

• Involved in Identifying and correcting any SQL Server related problems.

• Experienced with improving database server performance using Performance monitor after analyzing CPU, I/O and Memory usage.

• Administered the SQL Server security and assigned permission to developers and users.

• Used SQL Server Profiler to monitor and record database activities of particular users, applications.

• Experienced in working in the Clustering Environment to maintain the High availability.

• Installed multiple instance of SQL Server for development purpose.

• Maintained the production server with maximum availability.

• Experienced with setting up SQL Server and Database configuration.

• Experienced with creating DTS packages that performs extracts, data load tasks, movement of databases from development servers to production servers.

• Experienced with all aspects of database tuning methods like index tuning wizards, profiler, execution plans to optimize SQL queries.

• Created the standard operating procedures to install SQL Servers, SQL Clusters, service packs and security fix.

• Involved in 24*7 production support for SQL Servers.

Environment : MS SQL Server 2000, MS SQL Server 2005, T-SQL, DTS, Windows 2003 Server, SSIS, SQL profiler

Lincoln Financial, Hartford, CT Aug 2005 to Sep 2006 Role: SQL Server DBA

One of the largest financial companies, Upgrading the compensation reporting system, extract data from database and transform into future value SQL database and load it to the reporting system and financial department and at back office for further analysis.

Responsibilities:

• Worked as a SQL Server DBA, involved in production support.

• Installed SQL Server 2000, 2005 on windows 2000 and 2003 servers. Applied service packs and security fix.

• Configured and maintained transactional and merge replication for 4 different projects in production environment.

• Involved in data refresh activities from production to development servers.

• Experience in upgrading from SQL Server 7.0 to SQL Server 2000 servers.

• Experienced with improving SQL Server performance using performance monitor, index tuning wizards, SQL Profilers and execution plans.

• Created the database design for the development projects using Erwin tool.

• Involved in setting up the log shipping to create the backup server strategy.

• Installed Analysis services and developed OLAP cubes for dataware house project.

• Created the DTS packages to import the data from access, oracle databases to SQL Server.

• Created the backup strategy for production, test and development servers and implemented them.

• Worked with change management processes and maintain the documentation for SQL Server processes.

• Experienced with recovering SQL Server in a disaster conditions, performed production support for critical servers.

• Created the database maintenance plans every week for all the production servers.

• Experienced with database capacity planning and give system administrators about the hardware requirement.

• Involved in securing SQL Servers and assign the permissions to the users according to the business requirement.

Environment : SQL Server 2000/2005, T-SQL, Erwin, Enterprise Manager, Windows 2003 Advanced Server, SQL Profiler, DTS, T-SQL., Erwin, MS-ACCESS 2000.

Orbitz (Travelport Company), Chicago, IL Jun 2005 to Jul 2005

Role: SQL Server DBA

Provided ongoing technical support for all Microsoft SQL Server 2000 and 2005 production and development database servers.

Responsibilities:

• Manage SQL Server and data security, clustering, optimization, availability and recoverability.

• Provide SQL Server installation, configuration, patches installation, backup and recovery, replication, linked services, DTS to import and export data, SQL Server locking and indexing and error handling.

• Define and develop system-related policy, procedures, and documentation on database system administration monitoring, maintenance and optimization procedures as part of SOX compliance and internal auditing.

Environment : SQL Server 2000\2005 SQL Server 2000, Enterprise Manager, Windows 2003 Advanced Server, SQL Profiler, DTS, T-SQL., Erwin, MS-ACCESS 2000.

R-G CROWN BANK, CASSELBERRY, FL Jun 2003 to Apr 2005

Role: MS SQL Server 2000 DBA/DATA MODELER

C-G Crown Bank is a premier Florida bank with 33 branches, nearly 500 employees and one of the best banking leadership teams in the industry. C-G Crown Bank offers customers a broad range of first-class banking services.

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.

• 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.

• 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.

• Designed Logical and Physical Database Designing using ERWIN Tool.

• Involved different Data Warehouse techniques like Star-Schema and Snow-Flake schema.

• Implemented SQL/TSQL Stored Procedures/Functions.

Environment : SQL Server 2000, Enterprise Manager, Windows 2003 Advanced Server, SQL Profiler, DTS, T-SQL., Erwin, MS-ACCESS 2000.

Contact this candidate