Present Database Administrator Sample Resume Format in Word Free Download

Sample Template Example of Beautiful Excellent Professional Curriculum Vitae / Resume / CV Format with Career Objective, Job Description, Skills & Work Experience for Freshers & Experienced in Word / Doc / Pdf Free Download

                                        RYAN  PATTNAIK

                                  215-475-9876/ryan.pattnaik@gmail.com     

                                                 

SUMMARY

·         Over eight years of extensive experience with different phases of project life cycle (Analysis, Design, Implementation, Testing and debugging new and existing client-server based applications). 

·         4½ years of experience with Siemens Medical Solutions in Soarian Enterprise Database Architecture Team.

·         Experience in Installing, configuring and managing SQL Server 2008/2005.

·         Experience on Reporting Services (SSRS), Integration Services (SSIS), and Analysis Services.

·         Analyze the new features in SQL Server 2012(Denali).

·         Experience in implementing Disaster Recovery and High Availability concepts like Log Shipping, Mirroring, and Replication.

·         Experience in Database Design and Data Modeling using Erwin and Microsoft Visio.

·         Experience in creating SQL Server Reports using SSRS.

·         Actively involved in business requirements analysis, architecture design, physical and logical data modeling.

·         Strong experience in mentoring team members during a sprint, documentation and 24/7 production supports.

·         Good understanding of all phases of Software Development Life Cycle (Agile Methodology).

·         Experience in converting DTS packages to SSIS packages.

·         A member of Siemens Toast Master Club since July 2008.

EDUCATION

·            Master of Science,  Saint Joseph's University, Philadelphia                      

SKILLS

Programming language                          Java, C, C++, VB, T- SQL

Database                                              SQL Server 2000/2005/2008, MS Access, Oracle 9i

ETL                                                     SSIS

Reporting Tool                                     SSRS

MSBI tool                                             SSAS                                                                

Testing Tool                                          Mercury Quality Canter, Rational Test Manager   

Web Development                                 JavaScript, Ajax, Dream weaver, HTML, XML

Operating system                                  Windows 98/2000, Windows XP, UNIX

Other                                                    MS Office, SPSS, PowerShell                                                                                                                                       

EXPERIENCE

June ’07 – Present     Database Administrator/Sr. SSIS and SSRS Developer, Soarian Clinical, Siemens Medical Solution, Malvern PA                                        

Soarian Enterprise Database Architecture (SEDA) serves as a skill center for Soarian offering expertise in all aspects of database Administrator/development, tuning, and data access. The main purpose of SEDA is to provide an effective source of expertise and services for database development across the Soarian product suite.

The development process typically begins with understanding the Soarian database architecture and proceeds into data analysis, often including analyzing reports, all the way through logical data modeling

·         Install SQL server 2005/2008 on windows 2003 advanced servers, applied service packs and security fixes.

·         Manage and administer SQL Server 2005/2008 in production environment and active/passive clustered environment. Work to the max database of size 2 TB.

·         Set up database backup and recovery procedures for production, quality and development servers.

·         Implement Recovery Strategies and High availability like Database Backup and Restore, Database Snapshot, partitioning, Replication, Log shipping, Clustering (Active/Passive) and Database Mirroring.

·         Use Quest-Litespeed for Database Backup and restore of Database.

·         Hands on experience with Idera tools such as SQL Doctor, SQL admin toolset

·         Configure log shipping server to create stand by environment by configuring using a third party tool Redgate for high availability and synchronizing data.

·         Create users, user groups and maintains the access permissions. Configured SQL Security features and maintained the user administration.

·         Created Database Maintenance Planner for the performance of SQL Server which covers Database Integrity Checks, update Database Statistics and Re-indexing.

·         Monitor SQL server performance using profiler to find the performance and deadlocks.

·         Monitor and modify performance using execution plans and Index tuning, stored procedures.

·         Migrate DTS packages to SSIS packages.

·         Work on DTS packages for transferring data from various data sources like Oracle, MS Access, Excel, *.Txt file, *.CSV files.

·         Support development of Oracle database while migrating packages using SSIS

·         Design and maintain project databases using Oracle during the migration phase

·         Create solutions, projects and packages and managing them.

·         Work with various tasks such as Control Flow (Execute Sql task for each loop container, Data Flow task, File System and transformations such as Aggregate, Sort, Lookup, FuzzyLookup, Merge join, multicast, conditional split, derived column etc.

·         Create SQL objects like tables, stored procedures, functions, views, indexes, triggers, synonyms.

·         Work with logging and error handling in various projects.

·         Implement SCDs while history maintenance in tables.

·         Performance tuning at various levels like Source, Target, Destination and Transformations.

·         Create UNIT test cases and prepared technical specifications for SSIS packages.

·         Implement checkpoints at package level.

·         Create reports using SQL server Reporting Services(SSRS)

·         Create simple and complex reports using Report Server wizard.

·         Implement sub totals, aggregations and applied various formations.

·         Create Parameterized reports in SSRS.

·         Create chart, matrix, and other types of reports.

·         Create subscriptions and maintained the history using snapshots and caches.

·         Work on call 24/7 Support on weekly basis.

·         Used SSIS to migrate the tables to the Data Warehouse

·         Troubleshoot and conduct performance tuning of databases.

·         Wrote scripts that could modify more than a few rows (1000 or more), should be considered a downtime risk, and be evaluated as such.  Played a major role in bringing the port timings under 7 minutes.

·         Handle user permissions and space issues on Production and Semi-Production Servers and maintenance Jobs.

·         Work on Data Scrubbing technique to modify the existing data from information sensitive tables to avoid patient’s data cut into loose.

·         Generate readable database diagrams using Erwin, Drill-down into details from diagram to content - Navigable feature, Distinguish indexes from foreign keys.

·         Plan, design, and implement application database code objects, such as stored procedures and views.

·         Handle monthly database refresh in QA-Test environment for testing of new deployments and build.

·         Built and maintained SQL scripts, indexes, and complex queries for data analysis and extraction.

·         Ensure best practices are applied and integrity of data is maintained through security, documentation, and change management.

Environment:  MS SQL Server 2000/2005/2008, Java, T-SQL, DTS, Visual Basic 6.0, Visual Source Safe 6.0,Windows 2003 Server and Compuware QA Load test, HP Quality center,

C, C++, Rational Clear case, Rational Clear quest,

Jan ’04 – Aug ’05       Database Engineer ICICI Bank, Mumbai, India

ICICI Bank is India’s second largest bank that offers a wide range of banking products and financial services to corporate and retail customers through a variety of delivery channels. I worked on managing database for loan application which was uniquely focused to help the bank employees and clients manage their principal and interest payments.

·          Created and maintained databases, providing SQL Server security by assigning logins, server and database roles and server permissions

·         Proficiency in Performance Tuning, Query Optimization, Client/Server connectivity, and Database Consistency Checks using DBCC Utilities and DMVs.

·         Experience in SQL Enterprises Manager and SSMS – creating and scheduling jobs, alert and operators with SQL Server Agent, Backup/Recovery databases.

·         Extensively used tools like SQL Profiler for tuning and monitoring SQL Server performance

·         Experience in troubleshooting SQL Server related CPU, memory bottlenecks, I/O, disk space and other resource contention.

·         Created SQL objects like tables, stored procedures, views, indexes, triggers, synonyms.

·         Involved in automation of administrative tasks like creating jobs, schedules, alerts using SQL Server agent and monitoring and troubleshooting this jobs.

·         Used tools like SQL profiler for monitoring and tuning MS SQL Server.

Environment: MS SQL Server 2000/2005/2008, Java, C, T-SQL, DTS, Visual Basic 6.0, Visual Source Safe 6.0, Windows 2003 Server and Compuware QA Load test, HP Quality center

Jan ’02 – Dec’ 03       Database Engineer, ICICI Prudential, Pune, India

ICICI Prudential is a major provider of life insurance. Prudential’s data warehouse acquires data from various data sources within the company and helps integrate it from one source system to another. My project involved developing solutions for logistics, billing, vendor management and inventory management.

·         Conducted Performance Tuning, Query Optimization using DBCC Utilities.

·         Implementation of SQL  Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.

·         Worked on Stored Procedures, Indexed views, User Defined Functions (UDL), Triggers Distributed Queries and Common Table Expressions.

·         Wrote Stored User Defined Data Types, Procedures, Triggers and Functions  Rebuilding the indexes at regular intervals for better performance.

·         Designed and implemented comprehensive Backup plan and Disaster Recovery strategies.

·         Implemented and Scheduled Replication process for updating our parallel servers.

·         Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.

Environment: TSQL, MS SQL Server 2000, Enterprise Manger, Vb.Net, Windows Server 2003, IIS

Download Resume Format