06/25/2014 updated
RK
100 % available
MS SQL DBA
Cerritos, USA
USA
Bachelor Degree Microsoft WindowsUnit TestingBackup DevicesBatch ProcessingUnixChange ManagementComplianceDatabasesData MigrationData Transformation ServicesKorn ShellLog ShippingMicrosoft SQL ServersNetBackupOperations Support Systems
• Senior MS SQL Server DBA with 8+ years of IT experience in Database Administration, Design, Development, Installing and Support of MS SQL Server 2008/R2/2005/2000/7.0 in Production, Testing and Development Environment’s.
• Experience in Data Migration from MS SQL server 2000/2005 to 2005/2008/R2.
• Experience in implementing different types of Replication topologies involving Snapshot, Merge, Transactional and updatable.
• Implemented Backup and Restore in SQL Server using Native SQL Backups and also using Third party tools like Veritas NetBackup, Sandpiper, TSM and LITESPEED.
• Expert skills in VMware and Virtual environments
• Experience in Performance Tuning, Query Optimization, Database Consistency Checks using DBCC Utilities, Linked Servers.
• Experience in using different Transformation tools like DTS Packages, SSIS and also, BCP and BULK INSERT.
• Has good knowledge in implementing Log Shipping, Data Mirroring Techniques.
• Knowledge in Installing and configuring Cluster SQL Servers in Active/Passive and Active/Active environments.
• Experience in Software Development Life Cycle (SDLC) and configuring Alerts using SQL Mail.
• Expertise in planning and implementing MS SQL server Security and database Permissions.
• Well aware of SOX compliance, SQL Server change control management and Reporting Services.
• Experience in developing and supporting all stages of systems life cycle including Analysis, Development, Testing, Implementation and Product Support using T-SQL, PL/SQL on Unix and Windows environment
• Mid Level Experience as Database Developer for MS SQL Server, experience includes design and implementation of databases with MS SQL Server 2008/R2/2005/2000 on windows 2000/2003/2008/R2 servers
• Moderate experience with T-SQL in developing Database Objects, Triggers, stored procedures, Functions.
• Developed Oracle based (SQL and PL/SQL) programs for the creation of ad hoc queries/reports, including requirements gathering, design, coding and unit testing.
• Extensively involved in writing SQL queries (Sub queries and Join conditions), PL/SQL programming and Query Level Performance tuning
• Extensively worked on Collections, Bulk Binds, Bulk Collects and Table Partitioning
• Excellent in writing Shell Scripts using Sh, Ksh for database transactions and batch processing
• Generated DDL scripts for creation of new database objects like tables, views, sequences, functions, synonyms, indexes, Triggers, Packages, Stored procedures, roles and granting privileges
• Tuning of SQL statements using EXPLAIN PLAN, TKPROF, Oracle Hints to improve the performance
• Proficient in Oracle tools such as TOAD and SQL Navigator
• Experienced in Loading data into multiple tables using DB Management Tool like SQL*LOADER, Import /Export.
• Experienced in providing quality operational Support for Production Environments
• Experience in Data Migration from MS SQL server 2000/2005 to 2005/2008/R2.
• Experience in implementing different types of Replication topologies involving Snapshot, Merge, Transactional and updatable.
• Implemented Backup and Restore in SQL Server using Native SQL Backups and also using Third party tools like Veritas NetBackup, Sandpiper, TSM and LITESPEED.
• Expert skills in VMware and Virtual environments
• Experience in Performance Tuning, Query Optimization, Database Consistency Checks using DBCC Utilities, Linked Servers.
• Experience in using different Transformation tools like DTS Packages, SSIS and also, BCP and BULK INSERT.
• Has good knowledge in implementing Log Shipping, Data Mirroring Techniques.
• Knowledge in Installing and configuring Cluster SQL Servers in Active/Passive and Active/Active environments.
• Experience in Software Development Life Cycle (SDLC) and configuring Alerts using SQL Mail.
• Expertise in planning and implementing MS SQL server Security and database Permissions.
• Well aware of SOX compliance, SQL Server change control management and Reporting Services.
• Experience in developing and supporting all stages of systems life cycle including Analysis, Development, Testing, Implementation and Product Support using T-SQL, PL/SQL on Unix and Windows environment
• Mid Level Experience as Database Developer for MS SQL Server, experience includes design and implementation of databases with MS SQL Server 2008/R2/2005/2000 on windows 2000/2003/2008/R2 servers
• Moderate experience with T-SQL in developing Database Objects, Triggers, stored procedures, Functions.
• Developed Oracle based (SQL and PL/SQL) programs for the creation of ad hoc queries/reports, including requirements gathering, design, coding and unit testing.
• Extensively involved in writing SQL queries (Sub queries and Join conditions), PL/SQL programming and Query Level Performance tuning
• Extensively worked on Collections, Bulk Binds, Bulk Collects and Table Partitioning
• Excellent in writing Shell Scripts using Sh, Ksh for database transactions and batch processing
• Generated DDL scripts for creation of new database objects like tables, views, sequences, functions, synonyms, indexes, Triggers, Packages, Stored procedures, roles and granting privileges
• Tuning of SQL statements using EXPLAIN PLAN, TKPROF, Oracle Hints to improve the performance
• Proficient in Oracle tools such as TOAD and SQL Navigator
• Experienced in Loading data into multiple tables using DB Management Tool like SQL*LOADER, Import /Export.
• Experienced in providing quality operational Support for Production Environments
Languages
EnglishNative speaker