Database Architect Resume
SUMMARY:
A SQL Server DBA with Oracle and Windows Server experience in DoDTop Secret enterprise environments.
TECHNICAL SKILLS:
Servers, Systems: Windows Server 2003 - 2012 R2 | IIS Web Server | Red Hat Linux | UNIX | Sun Solaris | Fedora Linux | SQL Server 2008-2014 | Oracle 11g-12c | Oracle HTTP Server (Apache) | Linked Servers (OLE DB) | Data Warehouse | Business Intelligence Development Studio | Web Servers | Clusters | File Servers
Skills, Software: T-SQL | Pl/Sql | Windows Batch scripting | Linux scripting | Performance/Query Tuning | STIGs/SRGs | Backup/Restore | Security Management | Encryption | Failover Clustering | Patch Management | Indexing | Capacity Planning | Disk Management | Shared Resources NTFS, SFTP | Log Analysis SSMS | SSIS | SSRS | SQL Profiler | Tuning Advisor | SQLplus | RMAN | TOAD | Enterprise Manager | SQL Developer | UNIX Open VMS | Reflection X | VM Ware/Vcenter | Procmon | WinSCP | PowerShell | SQL Compare | Redgate Toolbet | Fortify Software Security | Sybase IQ | HTML/CSS | Visual Studio
EXPERIENCE:
Database Architect
Confidential
Responsibilities:
- Serves as Team Lead of Database Administrators for Confidential support at the Confidential
- Supports backend .Net/Cold Fusion web applications, and SharePoint content databases
- Enforces encryption in transit (SSL) on client connections to SQL, securing Top-Secret sensitive data
- Configures cyber security for database architecture to meet DISA STIG/SRG compliance requirements
- Configures Windows Server\SQL failover clusters, ensures high availability, mirroring and log shipping
- Monitors production performance; Tunes, indexes, execution plans, deadlock priority, & isolation levels
- Leads support efforts for Oracle web services and business objects database security management
- Executes Oracle imports/exports datapumps, cronjobs, SQL Agent Jobs and RMan backups/restores;
- Deploys quarterly Oracle critical patch updates, runs ACAS scans for SQL patch release updates
- Controls disk management, SAN requests, capacity growth, shrinks/scaling as transactions increase
- Analyzes file system and server event logs, SQL Server logs, and monitors NetIQ database server alerts
- Tests and deploys ETL processes via SSIS packages and supports SQL Server Reporting services
Systems Analyst, Application
Confidential, Washington, DC
Responsibilities:
- Liaised between developers & end users and routine database support in the Business App Division
- Monitored the health/disk space of SQL servers and front end Web servers that host Confidential applications
- Triaged local database issues, assisted customers with crystal reporting/business objects
- Serviced database requests and supported security management of Oracle and Microsoft SQL Server
- Performed system backups and recovery, and synchronization/extraction of Databases with clients
- Configured developer workstations with Sybase IQ/ASA, SQL Server, SAS, Teradata, client tools
- Installed and configured Confidential and OLE DB drivers and connection string to Sybase databases
- Performed routine audits of systems/software, verify and test backup policies
- Developed user guides /manuals, software installation, design specifications , and project/test plans
Systems Administrator
Confidential, Washington, DC
Responsibilities:
- Participated in the build, maintenance, enhancement, security patching of Windows and Unix systems
- Configured Windows Server 2008/2012 failover clusters, ensures high availability/load balancing
- Controls Active directory user/group management, organizational unit objects, and permissions
- Administered File services, NTFS permissions, and shared resources via Red Hat Linux/Windows
- Unix user account creation, editing, and removal. File system creation, modification and maintenance
- Configured SSL encryption, Kerberos delegation, trusted root certificates, secures data
- Performed routine audits of systems/software, deploys patches, hotfixes, and updates
- Used NetIQ to monitor system integrity and alerts, and analyzes file system and server event logs
- Conducted disk management, mount points, and performs backups and restores/recovery
- Developed/deployed system images and image updates; Bulk ghost imaging (Symantec Gghost Server)
- Configured and edited group policies, local policies and settings per administrative projects
Web Services Technician
Confidential, Upper Marlboro, Md
Responsibilities:
- Developed, designed web layout for all web services, sites and visual presentations
- Tested system software, and operating and system management systems; defining system specs
- Deployed and implemented various updates and code promotion from test into production
- Developed and maintained clients web sites and companies site
- Utilized specialized web app software to conduct operations and maintenance daily tasks
- Input database connection strings in configuration files for web app Confidential connection to databases
I.T. Specialist Intern
Confidential, Washington, DC
Responsibilities:
- Help desk phone support and ticketing, responded to help desk troubleshooting calls
- Developed service desk SOP’s and Knowledge Base troubleshooting documentation
- Clean Install, re-imaged and refreshed PC’s during XP Migration, configured special software
- Supported the Dept. of Commerce/BEA Desktop/Hardware Team, assembled Workstations
- Dismantled and removed all faulty hardware, compiled, inventoried and bar coded new computers
- Imaged new computers including Windows security updates and BEA standard software