Sql Server Human Resources
Resume:
HAMID AGHAZADEH
Summary:
I am a Sr. SQL Server DBA with over ten years of experience. This includes:
• Installed, maintained and patched the MS-SQL software; create, move, and upgrade databases.
• Created and Worked with T – SQL, Stored procedures, Indexes and triggers.
• Supported Production environment 7 X 24 to resolve issues and implemented changes.
• Proactively monitored the database systems to ensure secure servers with minimum downtime.
• Implemented and maintained clustering, data replication, Log Shipping, DTS/SSIS migration.
• Created backup jobs and disaster recovery processes.
• Created and worked with change management and problem tracking tools.
• Implemented and maintained security rules for SQL databases.
Education:
University of San Francisco
• Bachelor of Computer Science Graduated: 1987
Certifications/Training:
• MS SQL 2008, 2005, 2000
• System Administration for - Performance Tuning & Optimization for MS SQL Server 7.0
• Installing, configuring of Database for MS SQL 7.0 , 2000 and 2005
• Using DTS, SSIS to Populate Data Warehouse.
• ORACLE 7 Database Administration
• Solaris 2.X System Administration
• Tools I - Data Management Tools, Red Gate
• NT 4.0 Enterprise Technologies
• CNE
• Compaq, IBM, and Apple Certified.
Technical Skills:
Operating Systems: Windows 2008, 2003, 2000, Vista. XP, 2003, NT, and OS/2 Ver.2.01
Ancillary Skills: MS SQL Server 2008, 2005, 2000 , Oracle 8i, 7.3, People Soft 6.0, 7.0, 7.5, XP, SMS, SQL Server Clustering, Replication, , Log Shipping, Linked Servers
DTS, SSIS, Redgate SQL Compare, Sitescope, NetIQ, Sitescope, TCP/IP, RDBMS Level Two Training, SQA Tool, Crystal Reports, Cognos, TSQL, , pcanywhere, Remotely Possible, UnixWare, Novell 3.11, 4.01, NetWare Asynchronous Comm., Utility Programs - Netutil, Norton, PC Tool, VERITAS, LiteSpeed back up, - Arcserv version 4.02, Connected Backup
Hardware: DELL and HP servers, NT Cluster, NetFRAME Super servers, Novell Installation Configuration & Support, IBM AS400, System 36, VAX 11/785,Data General MV/10000, Laser, matrix and line printers, Compaq/Apple/IBM Certified on full line of products
Work Experience:
2009 - Present CTS, CA
Title: SENIOR SQL Server DBA
• Installed, configured, supported SQL server 2000, 2005 and 2008.
• Configured SQL replication, Log Shipping and SQL clustering.
• Managed various database projects and other IT projects.
• Created processes and provided directions to clarify business processes.
• Supported developers and users to resolve their issues.
• Worked with SSIS, SSRS and DTS packages.
• Performed database tuning and troubleshooting complex database issue.
• Used reporting tools, such as SSRS, Crystal Reports and MS Excel.
• Use TSQL to write scripts to format and filter data.
• Created tables, keys, indexes, views and stored procedures.
• Understood end-to0end data cycle and acquired data from systems and created data warehouses.
• Presented reports specifications and research analysis and database concepts.
2007 – 2008 County of Alameda, Oakland, CA
Title: SENIOR SOFTWARE ANALYST
• Installed, configured and tuned SQL 2000 and 2005.
• Managed SQL Servers in Production Environment
• Participated in on-call duty for out of hours problem resolution
• Planned, Scheduled and executed SQL server 2000 to 2005 Migration.
• Monitor SQL Server Performance and performed Tuning of SQL Servers for maximum Performance.
• Implemented and maintained data replication, Log Shipping., DTS/SSIS migration, data warehouse.
• Created and Worked with T – SQL, Stored procedures, Indexes and triggers.
• Documented processes to support Products
• Created SQL jobs for backups and maintenance.
• Created technical requirements and business reporting experience.
• Created processes, checklist for applying code changes or patches in production.
• Provided stability by using automation.
• Worked with SSIS and SSAS.
• Installed, configured and supported IIS.
• Supported and trained end users.
• Installed, configured Log Shipping, and Linked Servers, Replication.
Environment: Setup, Installation, Configuration, Upgrade, Performance and tuning of SQL 2000 and 2005 databases.
2006 – 2007 State Bar of California, San Francisco, CA
Title: SENIOR SQL SERVER DBA
• Installed, configured, maintained and monitor SQL 7.0 and 2000 Servers in Production.
• Supported Production, Development and QA departments.
• Installed and configured SQL replication, log shipping and clustering
• Organized SQL servers and databases in production and QA environment.
• Provided 7X24 support in Production environment.
• Install, configure and tuned SQL servers.
• Created technical requirements and business reporting experience.
• Created processes, checklist for applying code changes or patches in production.
• Created SQL server roles for security and access level for deferent users and departments.
• Monitor SQL server performance and space management.
• Performed SQL backups, maintenance and disaster recovery.
• Use TSQL for maintenance scripts.
• PeopleSoft administration.
• Cognos ReportNet 1.1 Authoring.
• Hummingbird administration.
Environment: Troubleshooting, Set-up and maintaining SQL Server 7.0, 2000 and 2005.
2000 – 2006 ADP, Pleasanton, CA
Title: SENIOR SQL SERVER DBA
• Created and Worked with T – SQL, Stored procedures, Indexes and triggers.
• Supported Production environment 7 X 24 to resolve issues and implement changes.
• Provided DBA support for remote SQL servers.
• Developed stored and other script to modify databases in production and client’s sites.
• Setup, maintained and provide access to production and test databases.
• Created Test environment in IT lab to test all patches in lab before production.
• Performed SQL Server Performance and Tuning.
• Designed, configured, maintained and monitor SQL 7.0, 2000 and 2005 Servers in Production.
• Responsible for capacity planning and space management database performance and monitoring.
• Installed, Configured, Managed performance on 30 SQL Servers in production environment.
• Installed and configured SQL replication, log shipping and clustering.
• Installed, Configured and maintained Crystal Reports.
• Supported and maintained various remote SQL servers for clients.
• Performed remote client upgrades and database maintenance.
• Worked with TSQL.
• Used DTS and SSIS in SQL 2000 and SQL 2005.
• Performed database administration and backups.
• Installed and configured Connected Backup software on SQL Server.
• Maintained documentation and checklist for all DBA’s tasks and other processes.
Environment: Support installation, configuration, and upgrade and maintain SQL server 7.0 and 2000 in production and remote clients.
1995 – 1999 PeopleSoft Inc., Pleasanton, CA
Title: SENIOR SQL SERVER DBA
• Administered SQL Servers in Production and QA environments.
• Installed, maintained and patched the MS-SQL software; create, move, upgrade, and delete databases
• Implemented and tested PeopleSoft Tools, PeopleSoft Financial and Human Resources on SQL 7.0 platform.
• Administered PeopleSoft Financial and Human Resources for Release Management.
• Supported Help Desk engineers on resolving user issues related to HR or Financials.
• Created and Worked with T – SQL, Stored procedures, Indexes and triggers.
• Resolved SQL issues related to PeopleSoft modules.
• Managed MS SQL Server 7.0 platform for system and platform testing.
• Configured servers for different database engine installations.
• Installed, tested, performed troubleshooting SQL server for various projects.
• Created, loaded and performance tuned databases for system and platform testing.
• Designed, implemented drop procedure from development to release management.
• Trained other DBA's for Release management and Demand planning.
• Installed, configured and tested People Soft HR, Financial and Student Administration.
Environment: Support installation, configuration, upgrade and maintain SQL server 7.0, 2000, Oracle and SBA online learning software in production and remote clients on Windows and UNIX.
1987 – 1994 Computerland Corporation, Concord, CA
Title: NETWORK ENGINEER
• Designed, Installed maintained and supported MS Network and Novell LAN's.
• Provided system Support for local and various remote Networks.
• Tested, evaluated and supported new software packages.
• Converted system 36/AS 400 Network to MS NT 3.51 Network.
Environment: Troubleshooting setup, upgrade Novell and NT on Compaq servers
Contact this candidate