OBJECTIVE:

Database Administrator

SUMMARY:

• Database administrator (DBA) with extensive experience designing, coding, testing and supporting next - generation database solutions. Proficient in an assortment of technologies, including Oracle 9i/10g, DB2, MySQL, Access, Sybase, MS SQL Server, JDBC, Visio, Apache Web Server, Java, C++, XML, Windows and Linux .

AREAS OF EXPERTISE:

• Database Administration
• Database Development
• Backup & Recovery & DR
• Standby/Failover Administration
• SQL Tuning & Optimization
• Database Security
• Capacity Monitoring
• Data Center Architectures

TECHNICAL SKILLS:

Application Software: MS Office 2000/XP, WordPerfect 5.1 and 6.0, Lotus 1-2-3, Release 2.4,5, Quicken 5, PowerPoint, Microsoft Excel and Word, Access 97/2000, dBase Ivv1. SQL, Microsoft Exchange Mail, Outlook, JDK, Seagate Crystal Reports 8/11, ArcView 8.1, ArcIMS 3.1, ArcGIS 8.1, portal technology (uportal 2.5.3), StudioEnterprise, Microsoft CRM, QNXT

Operating Systems: Unix, Linux (RedHat), MS-Dos, MS Windows, AS/400, SNA, Mac OS 8.6

Database Systems: Access97/2000, MS SQL Server 2000/05/08 R2/2012, Oracle 8i/9i/10g/11g, MySQL, Filemaker Pro, dBase III,Informix, Data warehouse, SSIS, SSAS, SSRS, OLAP/OLTP, ETL, EPIC(Clarity) DW, Tableau

Programming Languages: Client/Server/E-Commerce Programming, Unix Scripting, Relational Database(SQL), C and C++ language, Java1.1/Java Script1.2, CGI, Applets, Access97/2000/Visual Basic 6.0/6.5(ADO ActiveX, DAO), HTML Oracle developer/2000(Forms and Report Builder), Dreamweaver UltraDev 4, Flash 5, ColdFusion Studio 5, JAVA, XML/XLST, Mathematica, IBM Rose Model, Erwin, MSSQL scripting/programming, PowerShell

Database Monitoring Tools: SQL Diagnostic Manager (IDERA), Red-gate SQL Monitor, Solarwind, Hyena v12.0, spotlight monitoring tool, Nagio, Hyena, SQL Profiler

Accounting Software: ACR, MYOB, SBT, ADP, ILS, Peachtree 6, MAS-90, Quickbooks 4.0, BusinessWorks, Taxware

PROFESSIONAL EXPERIENCE:

Confidential, San Ramon, CA

Database Administrator

Responsibilities:

• Providing administration and monitoring to database system
• Diagnose and solve database problems, performance tuning and troubleshooting.
• Perform optimization, scripting & stored procedures, tasks automation and general database support.
• Monitor and support development, test, and production Database environments and databases.
• Maintain, support and monitor High Availability and Disaster Recovery technologies e.g mirroring, replication, log shipping, AlwaysOn, etc
• Maintain standards, guidelines, procedures (HIPPA) for the database infrastructure.
• Maintain, Develop and monitor the complete Business Intelligence solution in Dev, Test, UAT and production environments.
• Provide support to application developers in the use of the Database DBMS (SDLC).
• Create and maintain supporting documentation of Database environment and databases.
• On-call and after-hours support is required for this role.
• Provided support to ETL and DW processes e.g SSIS, SSAS, CUBE, SSRS.
• Worked with Redgate, Idera tools, CommVault, SnapManager, NetApp

Confidential, Burlingame, CA

Senior Database Administrator

Responsibilities:

• Provided complex database development, maintenance and enhancements in support of Enterprise Data Warehouse (EDW) and associated applications (HIPPA-EPIC-Clarity).
• Lead role in establishing database strategies in support of Enterprise Data Warehouse solutions.
• Provided database optimization support to developers building Data Warehouse and Business Intelligence solutions (SDLC).

Confidential, Rocklin, CA

Senior Database Administrator

Responsibilities:

• Troubleshoot, identify and resolve issues with Database database infrastructure.
• Support an enterprise database infrastructure with hundreds of databases.
• Troubleshoot and provide technical solutions to database issues encountered by new and existing applications in the environment.
• Troubleshoot and provide technical solutions to environment related issues encountered by new and existing applications in the environment.
• Provide upgrade, merger support for databases.
• Evaluate and implement new technologies for service improvement.
• Provide support to database and Operating system performance tuning.
• Actively monitor database platforms to increase efficiency, improve reliability, and minimize operating expenses.
• Responsible for coordinating service improvement projects as a technical lead, providing design and implementation standards to team members.
• Provide technical leadership to outsourced global development team thru project leadership and technical documentation and outage management.
• Provide on-going communication of status of projects and implementation.
• Analyze and tune application performance by optimizing SQL, stored procedures and triggers.
• Assist with stored procedure design and package development as required by development projects.
• Collaborate with other infrastructure teams to establish platform standards and best practices.
• Provide input towards the direction of future technology for Database.
• Coordinate with Web Infrastructure team in debugging web / database issue.

Confidential, San Mateo, CA

Senior Database Administrator (Sr. Database Architect)

Responsibilities:

• Architect, design, and implement large scale data management and business analytic solutions
• Installed, upgraded, configured, and tuned database systems including hardware, system software, and applications on Linux and Windows platforms.
• Monitored and maintained a high-level of database performance at all times.
• Analyzed system errors as well as specific server / storage performance issues.
• Formulated and implemented monitoring, security, and availability policies, procedures and standards relating to server and storage management.
• Developed and implemented HA database strategies( mirroring, replication, clustering)
• Performed database backup and recovery.
• Managed database updates to production using SQL scripts or other automation technology
• Script and/or develop in-depth application and database monitoring tools and recovery mechanisms.
• Maintained documentation of systems, policies and procedures
• Provided tuning and optimizing of SQL Server 2008 R2, 2012 as well as migrating, integrating, diagnosing and solving performance issues.
• Performed Migration and integration for Oracle 11g environments, MySQL and other DB systems

Confidential, Champaign, IL

Database Warehouse Administrator/Developer

Responsibilities:

• Provide database support for MSSQL 2008 R2, Oracle databases
• Developed and implemented HA database strategies( mirroring, replication, clustering), backup and disaster recovery plan
• Monitored and tuned database to improve performance
• Maintained and optimized a data warehouse supporting a BI application
• Administered SQL server 2005/2008 R2 databases in a Microsoft environment
• Generated and optimized stored procedures/functions for reports and web
• Provided ETL, SSIS, SSAS, SSRS process for data warehouse (OLAP/OLTP)
• Participated in database modeling, normalization and data mining.
• Participate in database application development (Oracle Application Development)
• Performed Migration and integration for Oracle 11g environments, MySQL and other DB systems
• Create/modify corporate reports/chart/graphics (Crystal Report 11,MS SQL data warehouse report, Oracle & Oracle Discoverer report, Mathematica report)
• Provided system analysis to improve/design corporate IT infrastructures

Confidential, Champaign, IL

Software Developer

Responsibilities:

• Participated in the implementation plans for newly created services(Portal/Portlet).
• Performed all steps of the software development life cycle from technical requirements gathering to preparing for project deployment.
• Completed technical development and integration projects that are based on agreed specifications, timelines, and milestones.
• Performed computer programming in Java/Java Scripts/SOAP/Perl/HTML/XML/XLST).
• Provided technical expertise in creating physical data models, creating database objects, and assisting developers with efficient SQL design and tuning (Oracle 10g).
• Designed and supported the data validation process.
• Established database security and enforce database standards.
• Ensured data backups and business continuity procedures are in place.
• Maintained modeling and analysis documentation (DBMS).
• Followed defined project management methodologies.

Confidential, Champaign, IL

Database Manager

Responsibilities:

• MS SQL sever2000/2005 and IIS 6.0 web server administration
• Provided database normalization support and DBMS modeling
• Monitored database performance and provided database security & optimization support
• Integrated various database from various data sources (Oracle, MS SQL)
• Managed database backups and restore process.
• Wrote front-end user interface in Access2000/Visual Basic for Desktop users
• Wrote data-driven web applications by using ASP, HTML, Coldfusion
• Incorporated GPS into projects by using ArcView 8.1, ArcIMS 3.1, ArcGIS 8.1