Imej profil rajesh2006
@rajesh2006
Ahli semenjak 20 Mac 2006
0 Cadangan

rajesh2006

Dalam Talian Luar Talian
Rajesh Malhotra Flat No. 4, Plot No. -174 Sector – 25, Pradhikaran Pune Ph: 9860080543 Introduction I’ve been working as SQL DBA for the past 5 years. My interest lies in creating complex queries to present data for different types of users and in database management and optimisation. I also like to experiment with database and customize it to the specific requirements of different customers. Currently Working With a CMM Level 5 Company (RapidIGM) Pune From Jun2005 Till Date At Present Working On a Dataware House Project for a U.S. Based Client as Senior SQL Developer Current Job Profile · Provide Expertise in at least load Monitoring, Performance Tuning / Change Management, Development Support, Planning for Growth of database, Backup / Recovery Planning · Provide metadata management plan and maintain the Data Dictionary and Data repositories · Support ultimate ownership of all data and make a determination of who may be granted the use of the data. · He should be aware of acceptable response times and be able to simulate that response. · Performing an impact analysis and stress testing before any changes are applied to the database. · Creation of tables, views, indexes, procedures, triggers, etc. that make up the objects used by applications Worked With Ebookers (U.K. based Company) Since Aug. 2004 To Jun 2005 Current Job Profile Worked as SQL DBA to provide DBA support and guidance to the CRM team that manages the web site of www.ebookers.com. The Job include the following responsibilities. My company is a UK based travel agency that has got offices at London, France, Germany, Norway, Switzerland, Spain and Netherlands With the back office operations At Delhi and UK. The job involves taking care of the Database servers lying at these locations. 1. Extracting all the data from these servers into one single database using DTS Packages. 2. Running all the Database maintenance utilities to keep the database optimised for use 3. Writing Stored procedures and scripts to run daily tasks of Data Import and Database maintenance utilities. 4. Working with the CRM Team Developers in writing SQL code to generate reports for the Business Analysts. Worked With Parsec Technologies Ltd. From Nov. 2002 till Aug 2004 Job Profile Worked as Manager Tech Support to provide SQL DBA support and guidance to a team of system administrators that manage our client sites across Delhi, Noida, and Gurgaon. The job entails: · Creation of Database which includes writing of triggers, SP’s & Indexes Constraints. · Periodic database tuning · Creating complex queries, stored procedures, batches to identify data related problems · Optimising database performance using indexes, triggers, system stored procedures · Resolving problems faced by the team of system administrators at the various client sites · Providing inputs to the development team on database designing · Planning backup and data recovery strategies · Have handled 400 GB of database and 15 servers. · Creation of Databases for the implementation of the CRM. Designing and Creation of necessary table structures in both the databases. There were 150 table created. · Creation of Indexes clustered and non-clustered on the tables. · Creation of Primary and Foreign keys and constraints on the tables. Providing support to the different team members stationed at various Client Sites. Managing individual database requirements of each client site in conjunction with team member. Project Experience · Worked closely with the development team to create a customized CRM software and designed the database for it. Subsequently, integrated the database with the running version of the dialer at the customer site in Hyderabad. · Created training manuals and trained users as well as system administrators at the customer site in usage of the dialer and the corresponding database. · Provided database administration support to client sites in terms of creating backup and replication plans. · Created complex queries and procedures at the new client sites to generate customized reports for debugging problems and tracing trends. · Created procedures and triggers to customize the standard dialer software as per customer requirements. Professional Qualification Skill Matrix for SQL DBA DBA area Rating Database design & normalization 3 Database creation 5 Database Tuning 5 Query optimisation 5 Backup & data recovery 5 Monitoring and optimising SQL server 4 Administering SQL Server using Graphical Administration tools which includes SQL Server Enterprise Manager, SQL Server Query Analyzer, Performance Monitors, SQL Server Profiler, 4 Importing and exporting data using DTS (Data Transformation Services) Wizard 5 Automating SQL Server Administrative tasks Using SQL Server Agents by defining jobs, Alerts and Events 5 Define Jobs (local / Multi - server), Scheduling Jobs, Running, modifying, Viewing jobs and Scripting jobs using Transact SQL Statements. 5 Managing SQL Server Authentication in Windows / SQL Authentication mode 4 Backing and Restoring of Databases (System and User Databases) 5 Integrating SQL Server with other Tools which includes SQL Mail 4 Configuration of Replication Model 5 Building queries using Transact SQL Server Statements for Automating Jobs, optimisation of SQL Queries 5 (1-Basic knowledge, 2-Some exposure, 3-Applied knowledge, 4-Applied in different contexts and 5–Proficiency) Previous Job Experience Worked as Manager Systems in a Pvt. Ltd. firm since June1998 Job Profile 1. Managing the database of all the customers of 10 exchanges and the database of pre-paid card systems in SQL 2000. 2. Monthly Bill Generation of all the subscribers 3. Generating reports for the director regarding the revenue collection from all the exchanges. 4. Managing the out station branches through E-1 5. Managing the Billing software of Internet. 6. Giving technical support to Customers for Internet installation 7. Looking after the network of 22 computers with 4 printers running on Windows-NT workstation with WINDOWS-NT Server. Educational Qualification 1. Completed 3 year degree course in B.C.A. (Bachelor in Computer applications) from Lucknow University in the Year 1994. 2. Done 10+2 from Delhi Tamil Education Association (D.T.E.A.) School Motibagh-II Personal Information Date of birth: 13th July 1972 Fathers Name: Shri. R.C. Malhotra Mobile No. – 9860080543 Nationality: Indian Languages Known: English, Hindi, and Punjabi (Rajesh Malhotra)
$20 USD/hr
0 ulasan
0.0
  • N/AKerja Diselesai
  • N/AMengikut Bajet
  • N/ATepat Pada Masa
  • N/AKadar Ulang Upah

Portfolio

Ulasan Terkini

Tiada ulasan.

Pengesahan

  • Facebook Disambung
  • Freelancer Keutamaan
  • Bayaran Disahkan
  • Telefon Disahkan
  • Identiti Disahkan
  • E-mel Disahkan

Cari Freelancer yang serupa