SUMMARY

Confidential

Database Administrator

Responsibilities:

• Works with client organizations to identify their needs (User Identification)
• Identifies, specifies, and recommends technical solutions to clients (Requirement Specification)
• Architects, designs, and deploys data management (RDBMS) solutions, data access and storage solutions for clients
• Designs, identify resources, and coordinates Data Management Projects on an on - going basis
• Prepares & designs databases, loads data from dump files into Oracle/SQL Server instances, performs ETL operations from other data sources into Oracle and MS SQL Server
• Monitors & manages project storage needs
• Responsible for performance tuning of Oracle and SQL Server databases
• Administers Oracle databases, RAC clusters, MS SQL Servers, and Application Servers
• Coordinates and executes clients’ database software patching strategies (critical patch updates and patch set updates)
• Provide database technology guidance to the development team
• Analyzes/recommends, and performs scheduled (and “as-is”) performance tuning, optimization, and database maintenance
• Provides overall Oracle/SQL administration expertise and undertakes administrative support
• Writes scripts for data processing to support analytic functions in the application solutions

Confidential

Database Administrator

Responsibilities:

• Initially worked in a team of systems/database administrators wholly responsible for the configuration and deployment of various server machines hosting email systems (Exchange), user/profile management (Active Directory), database management system (SQL Server and Oracle), web/application management (IIS Server), report management (SSIS, SSRS, OBIEE)
• Responsible for the evaluation, installation, configuration and management of all database software (Oracle 10g/11g database; SQL Server 2005/2008/2012), and related products
• Managed and maintained all database servers; responsible for the design, implementation and maintenance of Oracle Grid (node) infrastructure
• Performed software patching/upgrades, database design and development, creation and maintenance of database objects (including tables, views, cursors, indexes, triggers, functions, writing PL/SQL and T-SQL Stored Procedures, SQL scripts for altering the Database Schema
• Performed daily database functions using imp-exp utility, sql loader, DataGuard, SQL*Plus…
• Performed user/security audits (managed users, roles, object access, and privileges)
• Performed Security testing (simulated SQL injection), schema change management, performance monitoring & tuning, resource capacity planning and hardware optimization
• Used various tools (TOAD, Idera SQL Analyzer, SolarWinds DB Performance Analyzer) for database monitoring & management
• Established & maintained backup and recovery policies/procedure using RMAN and DataPump utility
• Performed on-request data transformation, integration and reporting (SSIS, SSRS) with SQL Server 2008 R2
• Maintained company-wide end-user documentation, backup & recovery documentation, general operational documentation (schema maps, standard procedure and policies, historical details, schedules, batch jobs (defined), future capacity planning)

Environment: Microsoft 2003/2008 Server Ultimate, Active Directory, Windows XP/7.0, .Net 3.5, SQL Server 2005, 2008, 2012 (SSIS, SSRS), Oracle Database 10g/11g, IIS Server 5.1/6.0, Visual Studio.Net 2005/2008, Microsoft Exchange 2003/2005, Microsoft Visio 2003, Microsoft Office 2003/2008, Microsoft Project 2008

Confidential

Database Analyst

Responsibilities:

• As a database analyst, I researched, analyzed, brokered, and deployed data management solutions for client companies based on mutually-agreed SLAs
• Developed, administered and maintained strategic roll-out plan for database deployments that supported specific organizations business models
• Worked with various business development and data management tools such as T-SQL, PL/SQL, SQL Server Query Analyzer, Oracle Scheduler, Enterprise Manager, Resource Manager, Oracle Forms and Reports, Crystal Report Designer, Oracle Designer, SQL Server, Oracle Database, Oracle Data Transform, import-export wizard, Microsoft DTS, Data Loader, Visual Studio for Application, Microsoft Visio, Microsoft Project
• Designed and implemented SLAs, system standardizations, security compliance and best-use policies for database access, data usage, and operational procedures
• Performed in-depth consulting services, training, and general DBA functions for clients:
• installed/configured/maintained various database engines (Microsoft SQL Server 2003, 2005; Oracle Database 9i/10g)
• created and managed databases, database objects, and defined data structures for client deployments
• user/access management, (Users, Roles, Privileges), database security (Oracle Transportable Databases; Oracle Secured Log-in), database management (Oracle Enterprise Manager, Backup & Restore Manager), node management (Oracle Clustering & Grid computing)
• Documented installation procedures, end-user policies, training, and database management procedures for clients/end-users
• Interfaced with both Microsoft and Oracle Corporations (with my active OTN membership) to proffer post-deployment support for clients.

Environment: SQL, PL/SQL, SQL Server 2003/2005, Oracle 9i/10g, .NET 3.0, Windows Server 2000, 2003, 2005, ADO.NET, OLEDB, Java, AJAX, Team Foundation Server (TFS), Microsoft Enterprise Library 5.0, Microsoft CMS 6.0, IIS 4.0, Microsoft SharePoint Server, Visual Studio .NET 2003

Confidential

Systems/Database Administrator

Responsibilities:

• Successfully upgraded company’s legacy hardware (running Windows NT 4.0), to a newer HP ML350 Generation 2 Server machine running Windows 2000 Enterprise Server
• Coordinated the computerization of all key operations of the company
• Designed, developed and maintained a company-wide Intranet Portal using Microsoft FrontPage 5.0
• Coordinated the roll-out of a newer, secure, and more robust multi-user Accounting package (Sage Pastel 3.0), as well as a manufacturing Inventory-control package (Solomon IV for Windows)
• Coordinated the deployment and maintained a Microsoft Exchange 2000 Enterprise Server running on Microsoft Communication Server for Medium Businesses
• Designed and implemented company-wide End-user Audit control and Security policy (Log-in, Password management, File/Folder access), using Intranet Forms-based Authentication and Domain-level validation control
• Planned, installed, configured, and managed the database engines (SQL Server 7.0/2000 Enterprise Edtn and Oracle 8/8i Standard Edtn) supporting both the intranet and enterprise solutions
• Developed and enforced database policies, standards, naming conventions, operating procedures and best practices; developed a strategic plan for the database development that supports the organizations operational requirements
• Created and managed database instances, structures, objects, and users for optimal operation of the various in-house Application software
• Managed the day-to-day running of the database systems for efficiency and availability: monitoring of Alert Logs and trace files, identifying and resolving bottlenecks in DB performances (resolving waits, identifying CPU-intensive queries, mitigating disk I/O contentions), tuning objects (memory/SGA, indexes, locks)
• Scheduled, performed, tested (and validated) daily, weekly and monthly DB backups using standardized tools/procedures to ensure database availability
• Coordinated DB access, usage and security; managed user accounts: created, modified and monitored user access rights & privileges
• Designed, developed and generated timely reports using Crystal Report
• Produced and maintained cross-platform database documentation and daily Administrative logs, arising from troubleshooting and resolving user issues and other database-related operations.

Environment: Windows 2000 Professional/Enterprise Server, Windows Communication Server, Microsoft Exchange 2000, SQL Server 7.0/2000, Oracle 8i Database, Crystal Report 4.0, Microsoft FrontPage, .Net 2.0, Visual Basic 6.0, Internet Information Server 3.0, Microsoft Visio 2000

Confidential

Systems Programmer/Analyst

Responsibilities:

• I worked as part of the application development team responsible for building top-notch IT solutions. Honed my programming skills doing the following:
• Employed adaptive design frameworks for implementing unbreakable, easy-to-manage, and shareable codes
• Adopted standardized functional design specification, annotated design architecture and programmable web structures
• Extensive collaboration of stakeholders throughout each project via the adoption of Software Development Life Cycle methodologies including Programmatic Task Iteration, Code Delegation, Code Reviewing, Multi-lateral Debugging, and Application Interface Testing
• Responsible for development and implementation of web user-interfaces on Microsoft .NET platform
• Performed constant server-side programming using C+/C++/Visual C++, FoxPro, Dbase and ASP
• Designed and implemented reusable program modules using Visual Basic/Visual C++ and Active Server Pages.

Environment: Visual Basic 5.0, Visual C++ 5.0, Object-Oriented Methodology, Forms/Reports Designers, Active Server Pages, HTML 2.0, .NET 1.0.3, ActiveX Programming, Java, SQL Server 7.0, Windows 98/2000 Server, Dbase 4.0, Visual FoxPro 5.0, Microsoft Access.