Bhargavi
Professional Experience:
Over 7 years of experience in Database Administration, System Analysis, Design, Development, Security and Support of MS SQL Server 2008/2005/2000/7.0 Enterprise Edition in Production, Test, Development, Replication Environment
Extensive experience in Installation, Database administration, Configuration, Backup & Recovery, Database Security, scheduling, log shipping, Data Transformation Services, Database designing and Query optimization, System Development Life Cycle(SDLC)
Migration experience in transferring database from oracle and Sybase to SQL Server
Good knowledge of object-oriented concepts and a fair understanding of component based architecture and database systems
Experience in developing T-SQL (DDL, DML) statements, Data Integrity (constraints), Rules, and Validation issues
Experience in creating Tables, Views, constraints, Indexes, Replication, and SQL joins and query writing
Proficient in the use of T-SQL for developing complex Stored Procedures, Triggers, Functions in achieving high performance
Experience in Performance tuning, using Performance Monitor/Profiler to solve Dead Locks/Long running queries and query optimization
Experience in creating and optimizing tables, indexes, schemas, views
Expertise in development, testing, maintenance, troubleshooting, analysis, modifications and documentation to improve build automation components and processes for greater flexibility and performance
Hands on knowledge in working with Data Migration Tools such as DTS & MS SQL Server Integration Services
Good Knowledge in designing reports using Crystal Reports and SQL Server Reporting Services
Highly motivated with the ability to work independently or as an integral part of a team and Committed to highest levels of professional and personal excellence
Worked on MS-Excel, MS-Access and Macros
Worked closely with management and users on database solutions
Worked on administration tasks such as Data loading, batch jobs, Data unloading, backup and recovery, user and application table management, upgrades, creating Databases/file groups/files/transaction logs
Well experienced on BCP, DTS packages, Jobs and linked servers for MS SQL Server/Oracle/ Sybase databases
Excellent verbal and written communication skills combined with interpersonal and conflict resolution skills and possesses strong analytical skills
Positive attitude towards superiors & peers.
Technical Skills:
RDBMS/Databases: MS SQL Server 2000/2005/2008, Oracle 8i/9i/10g, MySQL, MS-Access, Sybase
Data warehouse/ETL and: Data Transformation Services (DTS), SSIS (Integration Services), Data Stage,
Business Intelligence SSRS (Reporting Services), Crystal Reports and Analysis Services
Data Modeling and: Erwin, TOAD
Monitoring tools
Programming Languages: C, C++, C#, .net, JAVA, Java Script, HTML, DHTML, T-SQL,PL/SQL, JSP, PHP,PERL
Productivity Packages: MS-Office (Word, Excel, Access), Adobe Photoshop, XML, HTML
Educational Qualification:
Bachelor of Technology Engineering, India
Contact Info:
Bobby
bobby@openboxsolutions.com
