We provide IT Staff Augmentation Services!

Sql Developer Resume Profile

Waltham, MA

Objectives

I am a Microsoft Certified SQL Server Database Administrator and seeking a SQL DBA position to an organization that will allow me to utilize and develop my academy education and experiences and skills.

Personal Skills:

  • 6 years of Database Management experience in different environments
  • Excellent in customer service or clients support
  • Ability to adapt to changing environments
  • Excellent ability to work with team and quick learner
  • Development and maintenance of reports using SQL Server Reporting Services
  • Attention to detail
  • Proven record of liabilities and responsibilities
  • Excellent organization skills
  • Skills in a fast-paced environment
  • Excellent written and verbal communication skills

Experiences and Skills

Database Management:

  • Strong knowledge and working experiences as Database Administrator of MS SQL Server 2000, 2005, 2008, 2012
  • SQL Server Upgrade to later version
  • SQL Server Database Migration one server to another.
  • Strong working experience and knowledge with SQL Server Log shipping,
  • Database Mirroring,
  • Performance Tuning,
  • Database Backup/Recovery,
  • Query Optimization
  • Security Management

Built-In-Tools

  • SQL Server Configuration manager
  • Reporting Services Configuration manager
  • SQL Server Management Studio SSMS
  • Enterprise Manager EM
  • Activity Monitor
  • Query Editors
  • Query Analyzer
  • SQL Profiler
  • Database Tuning Advisor DTA

Third Party Tools

  • Toads for Data Modeling
  • Spotlight for Performance Monitoring

Operating Systems:

  • Windows Server 2008, 2008 R2, 2003
  • Windows XP Professional
  • Windows 7 Professional
  • Windows 8

Programming:

  • SQL
  • T-SQL
  • Trigger
  • Functions
  • Stored Procedures

Professional Experiences

Confidential

SQL Developer

Responsibilities

  • Performs all duties as assigned and necessary.
  • Capacity Planning for Servers and Databases
  • Install Configure SQL Server 2012, 2008R2, 2008, 2005 in development, test, and production environment.
  • SQL Server Database Upgrade from 2005to upper versions
  • SQL databases Migration into different MS SQL Server platform
  • Exported and Imported databases and database objects using Export/Import Wizard Copy Database Wizard
  • Very good understanding for manage, implement and optimize Relational database design
  • Create/ Implement database users, implement privileges, grant user permission, and perform auditing.
  • Establish and maintain sound Backup and Recovery policies and procedures
  • Experienced with Point-in-Time Recovery
  • Strong experience on database Monitoring and Performance tuning
  • Scheduled jobs to automate different activities such monitoring database health, disk space, job alert, index monitoring, stats monitoring and so on
  • Used DBCC to check database conditions, fix database corruption, rebuild indexes and other database Maintenance purposes as well
  • Understand T-SQL, Trigger, and Stored-Procedures, functions
  • Knowledge of SQL Server Integration Services SSIS
  • SSRS: Install configure Reporting Services SSRS
  • Deploy Stored Procedures, Functions, Triggers to production databases
  • Create Views for Developers to maintain database security
  • Maintain and update documentation
  • Installed, Configured and Maintained Database Mirroring.
  • Snapshot and Transactional Replication
  • Configured Log Shipping as Standby database from Production database for Reporting purposes.
  • Support Multiple IT, cross functional team, and Business Unit

Confidential

Responsibilities:

  • Performs and recommends capacity planning and management of database environments.
  • Responsible for the overall configuration management of the database technologies, including database installations, upgrades to new product releases and the installation of service packs.
  • Apply patches for Systems and SQL Servers.
  • Provide ongoing support for designated applications and databases.
  • Experience with SQL Server Upgrade to later version
  • Manage the deployment, monitoring, maintenance, development, upgrade, and support of all Database system.
  • Monitors and analyzes database performance, producing reports and recommendations for improvements as needed.
  • Performs database tuning for diagnosing issues and optimal database performance.
  • Manage security procedures for specific user, user applications, access to secure databases.
  • Manages backup and recovery of the database, including establishing standards and schedules for database backups, developing recovery procedures for each database and ensuring that the backup schedules meet recovery requirements.
  • Provide technical direction for Logical/Physical database design, maintenance, and administration.
  • Review developer SQL queries and stored procedures for optimization and security purposes
  • Used DBCC to check physical and logical consistency of databases
  • Working experience with T-SQL, Trigger, Function, Indexes, Constraints, File File Group.
  • Implement and Configured Log Shipping from Production to Standby Server Running as Reporting Server
  • Experience with ODBC Connection
  • Implement and Configured Database Mirroring for High Availability solution.
  • Export Import data from Oracle Database, MySQL, and Access Database including flat files like text, excel.
  • Write and maintain database and application documentation, including data standards, procedures, definitions for the data dictionary and logical and physical models of the databases.

Confidential

SQL Database Administrator

Responsibilities:

  • Performed capacity planning for SQL Server Instance Database.
  • Installed and Configure SQL Server 2000, 2005 2008R2 in development, test, and production environment
  • Experience in Operating System, Windows Server 2000, 2003 2008 .
  • Experience with SQL Server Upgrade to later version
  • Migrated databases within SQL Servers in test and production environment.
  • Identify and address database performance issues and capacity issues.
  • Strong experience in operational monitoring and management of databases to ensure maximum uptime and performance, Monitor Servers activity.
  • Tune and solve performance problems.
  • Experience SQL Server Error Log, space usage, DBCC Command,
  • Write T-SQL and Stored-Procedures. Assist SQL developers to optimize SQL queries and Stored Procedures.
  • Strong working experience in backup, restore and recovery procedures. Scheduled jobs
  • Strong working experience Maintenance Plan.
  • Export Import Databases.
  • Experience with Data Modeling: Designed Logical Physical Database, Backward Forward Engineering.
  • Involved in creating and modifying tables, Index Cluster/Non-Cluster , Constraints, Views, Stored Procedures, Triggers
  • Rebuild Servers Restore Recovered from tape/CD backup from backup
  • Configured Log Shipping from Production to Standby Server Running as Reporting Server
  • Configured Database Mirroring
  • Writing documents for Server and databases

Hire Now