System and database Administrator Resume Washington DC - Hire IT People

Objective

SUMMARY

More than Five years of extensive experience in Database Administration, in designing, Installing, and configuring high availability in SQL server.
Monitoring and tuning SQL Servers for better performance by using SQL profiler, Performance/System Monitor, Dynamic Management View/Function and Database Tuning Advisor.
Over five years of IT working experiences with a proven background of technical problem solving; Self - motivated, responsible, and reliable team player with a set of very strong technical skills.

TECHNICAL SKILLS

Software: Inland Revenue Tax system(SIGTAS), Customs System(ASYCUDA),WPS parking solutions

Languages: C++, Java, Shell Programming, T-SQL, PL/SQL

Project Management Tools: Microsoft project

Databases: SQL Server and oracle database

Hardware: Dell, HP, IBM

Tools: Idera SQL safe, SQL Profiler and Query Adviser, Toad

Operating Systems: Windows and Unix/Linux

Industries: Financial institute and services

PROFESSIONAL EXPERIENCE

Confidential, Washington DC

SQL Server Database Administrator

Responsibilities:

Plan, install, configure, and administer SQL Server, applying periodic service patch and fixes.
Set up and manage transactional log shipping, SQL server mirroring, and replication.
Design database backup and recovery plans and implement backup/recovery.
Monitoring and tuning Servers for better performance by using SQL profiler, Performance/System Monitor and Database Tuning Advisor.
Solid experience in performance tuning including updating statistics, re-indexing, structure modification, capacity planning and index analysis.
Developed SQL server database stored procedures, user defined functions, views and triggers to process business rules and data logic.
Scheduling and Automating Indexing, Backup, updating statistics using SQL Server job agent.
Create various reports according to the business requirements. i.e Install, deploy and manage reporting service using SQL server reporting service /SSRS.
Transform data to various sources using SQL Server Integration Service/ SSIS.
Automate and manage maintenance tasks
Database design, normalization, creating database, tables etc
Performance optimization by using Physical table partitioning.

Environment: SQL Server 2005/08, Windows 2008

Confidential

System and database Administrator

Responsibilities:

Provided Database and System Administration support and troubleshooting, include installation, Configuration, maintenance and modification of storage, network, Linux, and windows.
Configure and manage RMAN backup and recovery, and Oracle Enterprise Manager (OEM) for managing Oracle databases, hosts and other related components.
Provided Microsoft SQL Server Administration support and Plan, install, configure, applying periodic service patch and fixes
Responsible for logical and physical database design, implementation, and maintenance
Implemented on database refresh using full export for table level and full database defragmentation, resulting in improved performance and effective space management
Managing database security. Design, develop, and implement automated data backup and restoration procedures.
Configure data guard/standby server and Provide technical support for database maintenance and disaster recovery

Environment: SQL Server 2005, Windows 2003, Oracle 9i/10g, Red Hat Linux