SUMMARY:

• More than fifteen - years of broad experience with medium to large-size databases and applications management.
• Most expert on SQL Server database administration. - database maintenance, troubleshooting and solving database technical issues efficiently, ensuring database availability, database security, optimization, implementation of new changes and new databases, and providing 24/7 customer support.
• Strong Technical skills in SQL Server installation, failover clustering, upgrades, backup/recovery, replication, mirroring, and AlwaysOn.
• DBA Lead: Has experience in leading the DBA role. Evaluated database environments (current and new), proposed strategies and recommendations on specific configurations such as memory, disk configurations, backup plans, and file management.
• Developer: Designed and implemented databases (including ERDs, indexes, Triggers, and data integrity), and planned and lead the implementation of new database projects.
• Trainer: Provided technical mentorship and crossed-trained other peers and team members on SQL Server through design and implementation.
• Client lead: Worked on-site and remotely with clients on big accounts, and that boosted my client-handling skills and teamwork experience.
• Data Migration: Wrote setup plans and migrated multiple large-size databases from old servers to new SQL Server servers.
• Data warehousing: Knowledgeable in SSIS, Sagent, and DataStage for ETL
• Reporting: Used SSRS and SSAS for reporting and data analysis.
• Security and Active Directory: Use Windows group policies and SQL Server roles, and other necessary measures to make sure the right people have access to the right data.
• Oracle Database: Knowledgeable in Oracle. Performed server installation, configuration, upgrades, patches, database creation, space management, and daily database monitoring.
• Disaster Recovery: Developed step-by-step plans for disaster recovery on complex database infrastructure.
• Communication skills: Confident, good listener, professional, and experienced in written and verbal communication.
• Documentation: Excellent in documentation of procedures and setup plans, tracking issues and documenting changes.
• Research and development - Always researching new features, tool, and releases and applying it as it fit.
• Organized, dedicated, committed to quality work, self-motivated, energetic, and always ready to take an extra task. Skilled in supporting 24x7x365, mission-critical infrastructure.
• Capable of working efficiently from home.

SKILLS:

Databases: MS SQL Server, ORACLE, MS Access

Languages: SQL, UNIX Shell scripting, C++, Visual Basic, VBA.

Operating systems: Windows 2K…2K2012, Unix

Software: MS SQL Management Studio, MS BIDS( SSAS, SSIS, Reporting Services), Sagent, LiteSpeed, Capacity Manager, SpotLight, Nimsoft, Remedy, Magma, MS Office

EXPERIENCE:

Senior Database Administrator

Confidential

Responsibilities:

• Installed and configured SQL Server instances on multiple servers - Cluster and standalone.
• Gathered and documented database migration, including infrastructure and security requirements.
• Migrated massive amount of data into a new data center (that include databases, SQL Agent jobs, customized stored procedures, and logins)
• Setup high-availability environments—Used SQL Mirroring, AlwaysOn Availability Groups, and Log shipping.
• Developed and implemented strategies for data recovery - data backup and restore, data import and export.
• Maintained database satiability and security – setup backup jobs, have configured security audit, and have setup database and system monitoring alerts (CPU, disk usage, database growth, indexing, integrity checks….)
• Data integration: Setup and automated ETLs and reports using SSIS and SSRS
• Maintained understanding of all the database changes needs and the interactions between all components.
• Wrote stored procedures and different scripts using Transact-SQL programming language
• Coordinate with storage, network and Server engineering while building and maintaining different database environments to ensure availability and scalability.
• Recommend and implement solutions to database infrastructures to improve performance and reliability.
• Part of 24X7 on call rotation schedule for monitoring databases, responding to alerts, and working with clients on troubleshooting and solving efficiently production issues.
• Occasionally prepared and carried out presentations and training for team members.

Database Administrator\Contractor

Confidential

Responsibilities:

• Setup and configured multiple SQL Server servers – stand-alone and cluster servers (including patches, sql memory, and database mirroring)
• Migrated large-size databases to new servers by applying the Mirroring failover technology that made it seamless to the end user.
• Trouble shoot Performance issues and implement solutions accordingly (using DMVs, SQL Side Trace, and PerfMon counters)
• Monitor and trouble shoot various nightly SQL Agent jobs.
• Provide production support for all SQL Server databases (Database backup and restore, import and export data using BCP, users and permissions)
• Support Dev., QA and Production environment
• Work with customers through helpdesk tickets using FootPrints software.

DBA Consultant\Developer

Confidential

Responsibilities:

• Worked as the DBA lead. Managed Production databases including monitoring, optimizing, reporting, and security.
• Setup and configured SQL Server and applied company’s procedures and processes
• Setup replication site. I used snapshot replication that would occur nightly for reporting purpose.
• Setup mirroring site for automatic failover.
• Setup log shipping site for the purpose of failover at one point of time.
• Setup SQL Server Security: Setup new user-defined roles for specific users and specific access permissions (server level, database level, object level, and down to fields level)
• Installed and configured MS Report Services.
• Developed stored-procedures to archive old transaction data
• Applied various optimization techniques on existing queries and stored-procedure for enhancing performance.
• Supported 24x7, mission-critical infrastructure
• Operating Systems Used: Windows 2003 and Windows 2008

Database Administrator

San Francisco/CA

Confidential

Responsibilities:

• Supported a mixed SQL environment (2K and 2K5) with single and multi-instances on Windows 2000 and Windows 2003 operating systems.
• Performed SQL installation, configuration, upgrade, and applied patches.
• Setup and automated database-maintenance jobs (indexing, nightly backup and restore, database optimization, and more).
• Synchronized data between Development, Test, and Production for large-size databases (near a terabyte)
• Setup and maintained log shipping, SQL mirroring, linked servers, and replication.
• Worked on a data warehouse. Identified business requirements, built logical data flows from single or multi data sources, and designed ETL jobs.
• Monitored scheduled ETL processes for the data warehouse daily-data load and troubleshoot all related issues.
• Setup and automated a new failover site in New York using T-SQL, Litespeed, log shipping and mirroring.
• Documented the disaster recovery procedures for all the databases
• Supported multiple projects/tasks simultaneously.
• Worked with other IT teams to implement reliable hardware and software for Production environment.
• One of my last projects was working with the network team on an SQL database cluster environment.
• Provided continuous production support 24 X 7.

Tools used: MS Enterprise Manager and Query Analyzer, LiteSpeed, Capacity Manager for SQL Server, Spotlight for database monitoring and performance tuning, Lumignet for database auditing and security, Visio for conceptual models, Sagent and Integration Services for ETL, Reporting Services for reports.

Database and Application Administrator

Palo Alto/CA

Confidential

Responsibilities:

• Designed and developed databases such as for procurements, Loan-servicing, contracts, and many other tracking systems.
• Designed reports.
• Setup DTS, SQL Mail, and Replication.
• Setup database backup, restore, and “disaster recovery” plans.
• Provided technology training to non-technical end users.
• Performed SQL Server and Oracle Administration activities such as performance tuning, query optimization, maintaining transaction logs, security, and user management.
• Collaborated with the data warehouse project team to build a data warehouse (Oracle administration, ETL, and data modeling). For ETL, I used DTS and SQLLoader. For data modeling, I used Erwin Modeler and Visio. For PI, I used Seibel Analytics.
• Wrote installation instructions, users manuals and database documentations, includes ERDs and Data-Flow diagrams.
• Maintained various applications (Installation, periodical upgrades, troubleshooting, technical and user support).
• Trained technicians on application installation for clients and troubleshooting bank’s various applications.
• Supported clients in using various banking applications such as Navigator, Prime, PayplusUSA, ReconPlus, Cartesis. Image Director, Deluxe, Deposit Pro, Sales Pro, Tax Analysis, Service Desk, TPG, and OnePoint).
• Worked with the vendor to migrate the old Help Desk system (Magic) to a new system called CA Service Desk.
• Helped in mapping the existing management system (Magic) to the new system (Service Desk)
• Setup dashboards that showed incident and problem management processes
• Setup users and security and provided individual training for users
• Helped in pre-defining Test Cases to be tested by implementer and user
• Periodically, served as an administrator for Windows users and their Network access permissions.
• Partnered with auditors on the security of databases and applications.
• Worked with Network and Server groups in building servers and applying SQL and Windows security, Group Policy.
• Worked with Seibel Analytics (creating and scheduling canned reports).
• Tools used: Windows 2000 and Windows 2003, SQLLoader, Enterprise Manager, and TOAD, SQL Server, MS Access, Visio, Hyena, Crystal Reports, PI Seibel Analytics, Data Stage, Erwin,

Database Developer

San Francisco/CA

Confidential

Responsibilities:

• Designed, developed and implemented firm-wide databases using Microsoft Access and VBA.
• Maintained current databases. Modified the architecture of some current databases (including tables, indexes, triggers, and queries). Monitored SQL database backup and performance.
• Recommended solutions to correct malfunctions
• Developed implementation plans for various software, as needed
• Migrated data from legacy systems to SQL databases, dBase, and flat files.
• Migrated data from legacy systems such dBase and flat files to SQL databases using DTS and writing special queries.

Tools Used: SQL Enterprise Manager, MS Access, dBase, MS Office

IT Instructor

Confidential

Responsibilities:

• Taught Microsoft products such as Access, Excel, PowerPoint, Outlook, File Management, and Windows.

Network/Database Administrator

San Francisco/CA

Confidential

Responsibilities:

• Administered custom-made databases on Microsoft SQL Server platform
• Managed SQL Server procedures and Visual Basic codes for different applications
• Provided technical assistance to users from different departments
• Installed and maintained Windows NT servers and workstations and setup relationships between different domains
• Installed and configured computer software
• Performed troubleshooting for Windows NT domains
• Created user groups and individual accounts
• Performed daily, weekly, and monthly data backup for all servers and workstations using Seagate Backup Exec software

Instructional Aide

SanBruno/CA

Confidential

Responsibilities:

• Assisted individual students in learning different computer applications (word processing, spreadsheets and databases programs)
• Assisted students in selecting and using hardware and software appropriate for their needs
• Managed PC environment: Installed and maintained microcomputers on PC Window platforms in the computer rooms where classes were held and students did their computer work.