Post Job Free
Sign in

Sql Server Sales

Location:
Chennai, TN, 600084, India
Posted:
August 29, 2012

Contact this candidate

Resume:

SATHISHKUMAR.S

Email- ***.**************@*****.***

Mobile- 999-***-****

OBJECTIVE

To excel in the field of Information Technology as a Oracle Database Administrator by contributing continuously towards organizational growth by providing seamless database support and to utilize every opportunity to achieve both personal and professional development.

PROFESSIONAL SUMMARY

Around 1.3 Experience Years in IT Industry as ORACLE DBA for oracle 10g Databases

Having good experience in SQL server support environments including SQL server 2000 and 2005 as knowledge in SQL server 2008 as well.

Strong Knowledge in DBA activities like Backup & Restore, Job scheduling, monitoring the job, troubleshooting the job, working with SQL error logs, space management.

Good experience in maintenance plan, SQL logins, SQL server installation, configuring the database servers for development and test and production environments.

Knowledge in SQL Server objects event viewers, and activity monitor.

Able to deal situations falling under high severity with time constraints

Supporting the production system in 24x7.

Managed and monitored the use of disk space and the database space.

Managing tablespaces, data files, redo logs, tables and its segments.

Performing backup and recovery using Oracle 10g's user managed backup such as automated or manual cold backup and hot backup procedures.

Experience in RMAN, DATAGUARD (DR), Database Copying, and Database Migration

PROFESSIONAL EXPERIENCE

Working as a Database Administrator in Liatris Technology Solutions, Chennai from May-2011 to till date.

EDUCATION

Bachelor of Technology (Information Technology) under Anna University with an aggregate of 69%.

HSC from St.Paul’s Mat.higher secondary school, Nellikuppam, Cuddalore Dt, TN with an aggregate of 71%.

S.S.L.C from St.Paul’s Mat.higher secondary School Nellikuppam, Cuddalore Dt, TN with an aggregate of 70%.

TECHNICAL SKILLS

RDBMS Oracle 9i and 10g

Operating System Red Hat Linux, Windows 98/NT/2000/XP.

Languages SQL,C, C++

Database Tools Oracle Enterprise Manager Database Control, Rman,

SQL Loader

ETL Informatica 7.1/8.6

Project # 1

Client : ATP INC, Bangalore

Environment: SQL server 2005, windows server 2003

Role : SQL Database Administrator

Description:

This project has been classified into modules like Finance, HR, Operations, Dispatch and Sales marketing. Database contains various operational details about Cargos, Liner details, transportation materials, customs clearance details. Processing units like manifesting, verification units, IS information, CRM departments, input respective departmental data into the database, and will allow Database administrator to provide access and grant privileges to delivery and distribution departments to fetch the details for their operational activities. It’s a 24/7 availability environment which provide the customers service teams around the globe with the customer specific cargo status details to the end-users.

ROLES AND RESPONSIBILITIES

Sql server installation, maintenance plan and sql Logins

Backup and Restore Job and Scheduling, Monitoring the Job, Trouble shooting the Job, Working with SQL Error, Space management.

Identifying Chained Rows and rectify them.

Monitoring Production Databases on daily basis for performance and space related issues.

Periodical checking of alert log files and Verifying the integrity of backups

Handling Database backups using Hot and Cold backup

Project #2:

Client : Pfizer

Environment : Oracle 9i, informatica 7.x

Role : ETL Developer

Description:

Pfizer is the world’s largest life sciences company, committed to health and well being through innovative products and services, holds major investments in biotechnology and research. Beginning with corporate headquarters in New York. Pfizer IT rolled Business Objects out to its executives. Soon, other departments were seeing the value of the solutions; Marketing and controlling staff began Analyzing Marketing and sales data, now hundreds of users around the globe are maximizing corporate data in order to make better decisions. Managers are now able to determine market share, easily explore cost and profit data, and track performance of new products.

ROLES AND RESPONSIBILITIES

Analysis of the source tables.

Analysis of the specifications.

ETL mappings development

Used various transformations like Expression, Sequence Generator, Update Strategy and Router.

Initial extraction of data from source to target.

PERSONAL PROFILE

Father’s Name : Mr.T.Sridhar

Date of Birth : 27th Oct 1984

Verbal Languages : English, Tamil

Marital Status : Single

Passport : Valid

DECLARATION

I hereby declare that all the information furnished above is true to the best of my knowledge.

DATE : PLACE: (S.Sathish kumar)

SATHISHKUMAR.S

Email- ***.**************@*****.***

Mobile- 999-***-****

OBJECTIVE

To excel in the field of Information Technology as a Oracle Database Administrator by contributing continuously towards organizational growth by providing seamless database support and to utilize every opportunity to achieve both personal and professional development.

PROFESSIONAL SUMMARY

Around 1.3 Experience Years in IT Industry as ORACLE DBA for oracle 10g Databases

Having good experience in SQL server support environments including SQL server 2000 and 2005 as knowledge in SQL server 2008 as well.

Strong Knowledge in DBA activities like Backup & Restore, Job scheduling, monitoring the job, troubleshooting the job, working with SQL error logs, space management.

Good experience in maintenance plan, SQL logins, SQL server installation, configuring the database servers for development and test and production environments.

Knowledge in SQL Server objects event viewers, and activity monitor.

Able to deal situations falling under high severity with time constraints

Supporting the production system in 24x7.

Managed and monitored the use of disk space and the database space.

Managing tablespaces, data files, redo logs, tables and its segments.

Performing backup and recovery using Oracle 10g's user managed backup such as automated or manual cold backup and hot backup procedures.

Experience in RMAN, DATAGUARD (DR), Database Copying, and Database Migration

PROFESSIONAL EXPERIENCE

Working as a Database Administrator in Liatris Technology Solutions, Chennai from May-2011 to till date.

EDUCATION

Bachelor of Technology (Information Technology) under Anna University with an aggregate of 69%.

HSC from St.Paul’s Mat.higher secondary school, Nellikuppam, Cuddalore Dt, TN with an aggregate of 71%.

S.S.L.C from St.Paul’s Mat.higher secondary School Nellikuppam, Cuddalore Dt, TN with an aggregate of 70%.

TECHNICAL SKILLS

RDBMS Oracle 9i and 10g

Operating System Red Hat Linux, Windows 98/NT/2000/XP.

Languages SQL,C, C++

Database Tools Oracle Enterprise Manager Database Control, Rman,

SQL Loader

ETL Informatica 7.1/8.6

Project # 1

Client : ATP INC, Bangalore

Environment: SQL server 2005, windows server 2003

Role : SQL Database Administrator

Description:

This project has been classified into modules like Finance, HR, Operations, Dispatch and Sales marketing. Database contains various operational details about Cargos, Liner details, transportation materials, customs clearance details. Processing units like manifesting, verification units, IS information, CRM departments, input respective departmental data into the database, and will allow Database administrator to provide access and grant privileges to delivery and distribution departments to fetch the details for their operational activities. It’s a 24/7 availability environment which provide the customers service teams around the globe with the customer specific cargo status details to the end-users.

ROLES AND RESPONSIBILITIES

Sql server installation, maintenance plan and sql Logins

Backup and Restore Job and Scheduling, Monitoring the Job, Trouble shooting the Job, Working with SQL Error, Space management.

Identifying Chained Rows and rectify them.

Monitoring Production Databases on daily basis for performance and space related issues.

Periodical checking of alert log files and Verifying the integrity of backups

Handling Database backups using Hot and Cold backup

Project #2:

Client : Pfizer

Environment : Oracle 9i, informatica 7.x

Role : ETL Developer

Description:

Pfizer is the world’s largest life sciences company, committed to health and well being through innovative products and services, holds major investments in biotechnology and research. Beginning with corporate headquarters in New York. Pfizer IT rolled Business Objects out to its executives. Soon, other departments were seeing the value of the solutions; Marketing and controlling staff began Analyzing Marketing and sales data, now hundreds of users around the globe are maximizing corporate data in order to make better decisions. Managers are now able to determine market share, easily explore cost and profit data, and track performance of new products.

ROLES AND RESPONSIBILITIES

Analysis of the source tables.

Analysis of the specifications.

ETL mappings development

Used various transformations like Expression, Sequence Generator, Update Strategy and Router.

Initial extraction of data from source to target.

PERSONAL PROFILE

Father’s Name : Mr.T.Sridhar

Date of Birth : 27th Oct 1984

Verbal Languages : English, Tamil

Marital Status : Single

Passport : Valid

DECLARATION

I hereby declare that all the information furnished above is true to the best of my knowledge.

DATE : PLACE: (S.Sathish kumar)



Contact this candidate