Microsoft Access Developer Resume
5.00/5 (Submit Your Rating)
Ft Belvoir, VA
TECHNICAL SKILLS
- Language skills include programming in MS Access, Visual Basic, Visual Basic for Applications, SQL, Oracle, PL/SQL, Java, and C++. Operating system skills include Unix/Linux, Windows 2000, and Windows XP. Software skills cover SIMS, CMS, MS Access, Excel, and Outlook.
- SQL Plus, OEM (Oracle Enterprise Manager 11g), RMAN (Recovery Manager), putty, winscp, vi,
- Solaris (command line), Solaris Desktop Environment, NetBeans, Eclipse Development Environment, Merant PVCS Version Control, Ant Java utility, DB2, IBM Mainframe, PostgreSQL7, PostgreSQL8, PGAdmin, MySQL5 Administration Tool, MySQL Command Line Interface, Oracle10g Database Console, SQL Developer, Remedy, HP Service Manager, xml
PROFESSIONAL EXPERIENCE
Microsoft Access Developer
Confidential
Responsibilities:
- Responsible for maintaining Microsoft Access application in a Windows environment
- Extensive use of Visual Basic for Applications (VBA), as well as MS Access front - end and back-end databases
- Assisting in the development of User Interface (UI) forms, reports, and menus to facilitate efficient data entry
- Responsible for testing, verifying, and deploying new software updates as needed
Oracle DBA
Confidential
Responsibilities:
- Manage database objects such as tables, views, functions and packages
- Assist wif installation of patches and updates
- Create sql queries to gather important information about users, archive logs, table constraints, and other system properties
- Assist in the preparing the database for hardening as required by DISA STIGs
- Monitor space usage and space consumption on disk
- Monitor rman backups and daily data pump exports
- Consider methods to improve database performance
- Work wif application developers to explore efficient ways to fetch and manage data
- Establish audit logs and flashback logging
Junior Oracle DBA
Confidential
Responsibilities:
- Supported the Fusion Brain System which ingests data from multiple sources in order to provide a comprehensive noledge database of important data for military command centers utilized Oracle 11g, DataGuard, and ASM in a virtualized environment using VM Ware/vCenter performed post-cloning activities for database virtual machines; managed Oracle accounts in a Linux environment troubleshot database issues such as connection issues, ip conflicts, and user profile issues responsible for executing DISA STIG scripts to determine database, network, and system vulnerabilities able to clone, snapshot, and review general information of virtual machines involved in the documentation of system features and functions assisted senior DBA’s wif various database and system issues such as re-compiling invalid objects involved in the setting up of audit logs for the database
DBA Surge Support/Software Tester
Confidential
Responsibilities:
- Worked on a temporary surge-support project primarily involved wif Oracle and Sybase upgrades
- Responsible for performing vital pre-requisite checks on Linux/Solaris servers to ensure they are adequately prepared for Oracle grid, RAC, and single-node database software
- Served as a liaison between the DBA team and Unix system administrators and storage engineers
- Utilized pre-built Unix scripts dat test kernel parameters such as memory size, swap space, and file permissions in preparation for new database software; providing regular updates to managers in the progress and status of upgrade process and maintenance windows
- Executed Unix scripts to fetch data from the data repository to satisfy audit requests from management personnel (occasionally made alterations to shell scripts using vi and python)
- Attended weekly status meetings wif entire database management team to discuss procedures, issues, resolutions and work-arounds
- Worked on a team to halp ensure software quality for the FBI Sentinel Program
- Handled Service Manager trouble tickets involving the Sentinel Case Management System
- Provided effective and timely customer service assisting FBI personnel resolve issues related to the Sentinel system
- Attended daily status meetings to stay informed of system-wide network and database concerns wif other team members
Database Administrator
Confidential
Responsibilities:
- Worked as an Oracle DBA in the Joint Operations Support Center (JOSC)/Joint Staff Support Center (JSSC) at the Defense Information Systems Agency (DISA)
- Responsible for monitoring databases, applications, reference files, and interfaces in the Joint Operation Planning and Execution System (JOPES) and Global Status of Readiness and Training System (GSORTS)
- Work wif clients, customers, and other agency officials to assess their needs, provide information or assistance, resolve their problems, and satisfy their expectations
- Possess a thorough noledge of DISA's Information Assurance policies and requirements
Database Assistant
Confidential, Ft. Belvoir, VA
Responsibilities:
- Served on a temporary assignment to assist during a transition period
- Worked wif other Database Administrators to gather system and database information from incumbents
- Helped to gather information about database configurations such as High-Availability Pairs, Oracle Grid, and Real Application Clusters
- Worked briefly wif IBM’s DB2 on mainframe systems
- Served as the Database Manager responsible for database maintenance, installations, back-ups, and data manipulation
- Maintained databases in a MySQL and Oracle environment using MySQL Administrator and Oracle Enterprise Manager Console as GUI tools and MySQL Command Line and SQL Plus for CLI-related tasks
- Devised various SQL scripts to check the status of system catalogs and user tables
- Responsible for data migration from Postgres7 on Solaris 10 to Postgres8 on Red Hat Linux
- Worked extensively wif system administrators and Java/C developers to coordinate the effective flow of data between various subsystems and operating platforms
- Designed detailed database documentation (for use by outside organizations) to explain typical installation procedures including initializing data spaces, creating databases, backing up/restoring databases and the like
- Constructed other useful materials, spreadsheets, and data flow diagrams to facilitate the management of database concepts and features
- Provided valuable input at monthly meetings including the explanation of features and flaws of current database applications
Microsoft Access Developer
Confidential, Washington, D.C.
Responsibilities:
- Served as the IT Security Specialist Assistant for the Diplomatic Security Branch of the State Department
- Responsible for managing, researching, and updating personnel data in SIMS and other commonly used Security Clearance-tracking databases
- Using Microsoft Access, Visual Basic, and advanced SQL statements, developed an intricate program dat converts tabular data into readable XML code used for updating intranet databases
- Designed numerous programs, forms, and macros using Visual Basic and SQL dat reduced time and money
- Made important modifications to existing systems dat provide tremendous improvements to data-flow efficiency
