Database Administrator/ Sql Programmer Resume
3.00/5 (Submit Your Rating)
San Diego, CA
SUMMARY:
- Highly motivated SQL DBA. Experience in Data Warehousing settings in both SQL Server and Oracle environments.
- Proficient in SQL Database Administration; providing database upgrades, installation configurations, backups, restores, and performance tuning.
- Strengths include managing multiple projects following SDLC processes when implementing enterprise applications including validated systems.
- Experience in maintaining Microsoft SQL 2008r2, 2012, and 2014 Servers
- Proven ability to identify, launch, and manage multiple applications and services in fast paced environments.
- Foreign Languages: Spanish
TECHNICAL SKILLS:
Operating Systems: Microsoft Server / Windows
Programming Languages: C#, VB Scripting, XML, TSQL, PLSQL, HTML
Technologies/Tools: SQL Server, Oracle, SSIS, ETL, SSAS, SSRS, Crystal Reports, Idera (SQL Safe, SQL Diagnostic Manager), SQL Developer, IIS, Toad, Apache, VMware ESX, vSphere, Tableau
PROFESSIONAL EXPERIENCE:
Confidential
Database Administrator/ SQL Programmer
Responsibilities:
- Responsible for ETL tasks including extracting, updating, and reloading client data as well as receiving raw files from client. Transforming data and loading new data on a weekly and monthly basis. Responsible for troubleshooting and correcting anomalies.
- Utilize SQL Server Integration Services to develop packages enabling automation for data loads increasing efficiency and reducing manual tasks.
- Provide ad hoc reporting as well as standard reports utilizing SQL Server Management Studio and SQL Server Reporting Services.
- Provide data visualizations through Tableau by building custom dashboards based from requirements provided by clients.
Confidential
Sr Programmer/ Analyst
Responsibilities:
- Responsible for North Island’s SQL Server environment consisting of 2008r2 2012, and 2014 SQL Servers; includes database upgrading, installation, configuration, maintenance, developing backup procedures, and database restores. Managing accounts and permissions. Provide after-hours support.
- Setup migration, upgrade, and documentation for multiple SQL Server instances. Migrated from SQL 2005 to SQL 2008r2.
- Utilize SSIS for ETL tasks; Responsible for developing SSIS packages for utilizing data from multiple data sources.
- Responsible for meeting with business units, turning requirements into technical specifications. Develop Business Intelligence reports and customer mailers from SQL Server, Oracle, MySQL data sources utilizing SSRS and Crystal.
- Responsible for maintaining North Island’s Oracle 11g Database; manage team during offline activities, as well as, re-directing transactions during upgrades.
- Project Management; implemented multiple applications within the organization developing project plans, utilizing the Software Development Life Cycle while following waterfall and agile methods.
- Manage developer on team; Responsible for directing, mentoring, and training. Assist with career growth, managing project prioritization and provide guidance during code review.
Confidential
Sr Systems Analyst
Responsibilities:
- Develop financial reporting in a Data Warehouse. Utilized SSRS for reporting and SSAS for analysis. Met with departments to gather requirements, develop report specifications and uploaded to share point. Created reports in development environment. Developed user acceptance testing. Upon approval, uploaded report to production environment.
- Project Lead to increase efficiency and consistency across all departments. Created process-flow diagrams. Updated documentation to standardized processes and improve effectiveness. Communicated new processes with departments by conducting training sessions. Created user acceptance testing. Implemented new configurations into development environment and migrated into production environment as appropriate.
Confidential
Sr Systems Analyst
Responsibilities:
- Responsible for integrating Confidential ’s systems and databases such as SQL Server, Oracle (including Oracle’s Database Cloud Service), Postgres, with SailPoint’s Identity Management software. These integrations enable Confidential to address compliance, regulatory mandates and requirements as well as provide preventive and detective controls enterprise-wide.
- Responsible for requirements gathering in support of over 190 integrations.
- Functionally managed team of five Security Analysts.
- Utilize tools such as SQL Reporting Services to enable status communication within group.
- Performed data validation for each integration utilizing data querying and data analysis
Confidential, San Diego, CA
Systems Analyst II
Responsibilities:
- Responsible for SQL Database Administration of SQL Servers 2000, 2005, and 2008r2; provided database upgrades, installations and configuration, backups/restores, and performance tuning.
- Migrated/upgraded SQL Servers from 2000 to 2005.
- Provided database reporting to multiple departments utilizing SQL Server Reporting Services. Global Information Services successfully leveraged reports to manage new hire allocations for a rapidly growing infrastructure; Confidential grew by 150% between 2008 - 2010.
- Assisted developers and scientists with application development by importing raw data from Confidential ’s DNA analysis instruments and LIMS systems utilizing SQL Server Integration Services.
- Responsible for playing key role in multiple phases of application deployment. Installed, configured, documented, and managed multiple environments of enterprise applications by creating and implementing processes to ensure successful deployments from the development phase to the production phase in a regulated environment.
- Concurrently maintained six enterprise applications as System Administrator
- Initiated “Insight Software” application. An ERP reporting tool which reduced financial analysis time by 200%.
- Developed HelpDesk dashboard in C# and utilizing connection string to HelpDesk SQL Database
- Worked closely with Software QA department when implementing regulated systems during SDLC phases of project.