We provide IT Staff Augmentation Services!

Sql Developer Resume Profile

GrotoN

Executive Summary:

Satisfying and challenging positions to utilized and build on the considerable skills and experience I have already acquired and developed.

Core Experience

  • Data Migration
  • Backup and Recovery
  • Installation and Upgrade Integration Service
  • Performance Tuning Disaster Recovery
  • High Availability

Skills Summary

  • Database Installation, Configuration and Maintenance, Administration of SQL Servers 2008R2/2012.
  • Implementing High Availability of database servers using Database mirroring, Log Shipping and Clustering. ETL using SSIS- Data Warehousing.
  • Creating jobs, Alerts, SQL Mail Agent.
  • Perform integrity checks. Methods include configuring the database maintenance plan wizard and DBCC utilities. Experience on 64 bit SQL Server 2012.
  • Ability to work in a fast paced environment, Good team player and who can also work independently. 24 X 7 Production Database on Call Support.

Career Profile

  • Detail-oriented, efficient and organized professional with experience in accounting systems.
  • Possess strong analytical and problem solving skills, with the ability to make well thought out decisions. Excellent written, oral communication and time management skills.
  • Highly trustworthy, discreet and ethical.
  • Resourceful in the completion of projects, effective at multi-tasking. High sense of urgency and Flexible to working overtime.

WORK EXPERIENCE

confidential

SQL Server DBA

  • Tools like SQL Profiler and SQL trace for troubleshooting, monitoring, optimization of SQL Server
  • Engaged as demand in DBA duties including: database backups, restores, performance tuning, and capacity analysis. Develop, modify, and optimize stored procedures, triggers to handle complex business rules and history data
  • Management of production and development databases including performance tuning, capacity planning, SQL Server clustering, database security configuration, and SSIS packages.
  • Tuned stored procedures, advanced queries, triggers, views, indexes, and functions for databases. Team with end users to define, implement, and maintain their reporting requirements.
  • Participate and coordinate the creation, modification and maintenance of database structures.
  • Full management of database users and security: Assigning users to data bases and determining the proper security level for each use also assign permission to the various database objects such as, Tables, Views, and stored procedures
  • Create, deployed and managed ad-hoc report using the SQL SSRS reporting tool.
  • Demonstrated high level of understanding of database internals and application database components e.g. triggers, functions, packages
  • Provided consultation, training and mentoring to all application developers in database management practices as it pertains to SQL databases
  • Knowledge of installing and implementing Microsoft SQL Azure the cloud based database solutions.

confidential

SQL Server DBA

  • Use SQL Profiler for troubleshooting, monitoring, optimization of SQL Server
  • Perform DBA duties including: database backups, restores, performance tuning, and capacity analysis.
  • Develop, modify, and optimize stored procedures, triggers to handle complex business rules andhistory data
  • Manage the production and development databases including performance tuning, capacity planning, SQL Server clustering, database security configuration, and SSIS packages.
  • Create stored procedures, advanced queries, triggers, views, indexes, and functions for databases. Work with end users to define, implement, and maintain their reporting requirements.
  • Participate and coordinate the creation, modification and maintenance of database structures.
  • Manage database users and security: Assigning users to data bases and determining the proper security level for each use also assign permission to the various database objects such as, Tables, Views, and stored procedures
  • Demonstrate an understanding of database internals and application database components e.g. triggers, functions, packages
  • Develop, deployed and managed ad-hoc report using SSRS.
  • Applied knowledge of database design standards and database management systems DBMS to the resolution of daily database issues.

confidential

Junior SQL DBA

  • Configured Transactional Replication and Log Shipping with SQL Server Management Studio as well as basic account management and troubleshooting with connectivity, security and firewall issues.
  • Conducted Performance Tuning using SQL Profiler and Windows Performance Monitor. Configured Database mail, linked servers in SQL server 2005.
  • Creation and scheduling of Maintenance plans database and log backups and cleanups , DTS to SISS package conversions.
  • Implemented MS SQL Cluster Active/Passive Active/Active , Multi Node Cluster up to 8 Node for high availability.
  • Writing, debugging, and tuning Transactional SQL, ETL and stored procedures for developers and customers SQL Server database physical model creation and implementation data type, indexing, table design
  • Developed, deployed and managed SSIS, SSAS, SSRS and published them for end users
  • Setting up and administering SQL Server Database Security environments using Profiles, database Privileges and Roles.

Hire Now