Optimizing imbedded SQL in perl/shell scripts for faster completion time; from hours to minutes. Use our Job Search Tool to sort through over 2 million real jobs. To write great resume for azure architect job, your resume … Find and customize career-winning Azure Architect resume samples and accelerate your job search. Developed criteria, based on database design requirements, for selection of a report writing software platform for a new web portal project. Computer Sciences And Electrical Engineering. Assess root causes for bug or production problem. Worked with application development team or project management regarding project planning, resource allocation, task definitions and schedules. Lead architect on commercial accounting system for the film industry. Solved critical and non-critical tickets using SalesForce.com or JIRA ticketing system. Quickly Customize. Picture a hiring manager's desk. Assisted the team with migrating to TFS from Perforce. Leads troubleshooting and performance tuning in Verimatrix Global services Team. Backend consists of a stage database and a data warehouse. Environment:Oracle10g, Solaris, Oracle Designer, OEM, RMAN, DataGuard, OWB, CVS, PL/SQL, XML. Full life cycle Sybase and MS SQL Server database administration. Designed, structured, and maintained the large and complex DOD, VA, CROSS, and LOGGING databases for Federal Health Information Exchange (FHIE). Most of the time they’re only about your name, your contact and location. Participated in British Petroleum (BP) Hurricane Management System (BP-HMS) for 2006 Gulf Mexico Hurricane season. Fine tuning of the cluster disk subsystem. Defined data tables, indexes, and interfaces for database applications. Developed ER/Studio administration standards and processes for ER/Studio data model and repository management, and the publishing of metadata through the ER/Studio Portal. Supervised developers and approved code before it moved into production. Database architect to reengineer numerous databases across multiple business units and to develop normalized schema models for VLDB and MDDB repositories. Get Hired Easier with Architect resume sample Using Architect resume samples can help you format and write your own Architect resume so you can get hired for your next job. Designed a database to support the web application clustering. This led to a decrease in database outages; from 10 per month to less than 2 per year. In the same way that it’s important to your chances of landing the job for the job seekers to be well-groomed and dressed like you’re serious, so should your architecture resume. Supported team member responsible for insuring databases were mirrored and all redundancy aspects were fulfilled including creating mirrored packs and adding or reducing pack families. Architected solutions for migrating applications and databases to new environments and infrastructures. All reports were localized and globalized in 5 separate languages, Responsible for merging CER database with [company name] Operations Management (MOM) database, Worked on project through entire [company name] life cycle, from product planning, design, coding, code review, threat analysis and shipping. Database Architect Resume Samples Database Architect Resume. Defined data tables, indexes,... Education. Location Feature Server is a .NET (written in C#) based server product which enables organizations to view their data overlaid as intelligent, interactive features on Microsoft Virtual Earth map, Google map and other base maps. Developed digital signature capture system for generating receipts and contracts. Provided database coding to support business applications using T-SQL and PL/SQL. Project manager for implementation of a web-enabled accounts reconciliation application to facilitate rapid closure of financial transactions for quarterly and annual accounting periods. Drafted database optimization standards for universal adoption using Oracle, DB2UDB and Sybase including system, database and SQL best practices and optimization techniques. Typical duties listed on a Database Architect resume sample are collaborating with developers, assisting end users, designing databases, analyzing data, and modeling and migrating data. Training the developers of the company in writing efficient database code. To become a data architect, you should start with a bachelor’s degree in computer science, computer engineering or a related field. Produced conceptual, logical and physical data models, metadata, and Oracle DDL using ER/Studio Data Architect. BA/BS and 10+ years’ experience. Lead for Data Architecture and Business Intelligence on variety of projects. Work on Business Intelligence teams on redeploying DB2 code to be handled more efficiently by Oralce database preventing an entire re-write of the application. Successful example resumes also mention computer proficiency. Provide support in database architecture of the organization through database design, modeling and implementation. Currently leading the effort to migrate Sybase ASE Servers from version 15.5 to 15.7, and Sybase replication servers from 15.6 to 15.7 version. Promoted to lead position and manage Data Warehouse DBA after six months. Responsible for migrating databases systems from BofA to Merrill Lynch's environments. Managed Quality Assurance teams testing the software. Implemented the ETL process using plsql stored procedures, cron batch jobs and shell scripts. Providing 24X7 support for the database issues related to product and web sites. Design and implement practices for improved performance and resource usage. Upgraded the oracle application 10.7 to 11i4 on sun Platform. Excellent oral & written … Performed SQL query optimization through use of SQL Profiler, appropriate indexing, reducing use of cursors and reducing load on tempdb. Responsible for performance/tuning of all the instances. Designed User, Functional and Technical Design Specifications and created EDC forms to capture clinical data. Designed the peer review process and procedures. Routinely ran database backups, restores, maintenance plans, reporting of data, security, and health of databases on servers with internal and external customers. Re-designed the enterprise consolidated schemas for rapid reporting services. All rights reserved. Created the process to restore the production database at the new data center. I search for a position of Database architect … Mentoring database developers on SQL code standards and best practices. By doing so, you’ll present yourself as a true professional and this will increase the likelihood of you getting hired as their new Architect.Contact in… Combined with the UI toolset in Flash named LFS Visual, LFS enables organizations to unlock and reveal significant trends, patterns, anomalies which are "locked up" or latent within their various data sources. Analyze, design, implement tools to monitor and improve data quality in different CRM systems (Siebel, msorg) using SQL Server 2005. As Senior Database Architect for the BIS application suite developed for the US Navy, PMRF, was responsible for all aspects of software design and development; Requirements analysis, development, data manipulation and loading, documentation and coding standards, implementation, and training of users. Implemented, configured, and administered replication for MS SQL 2005 Servers. Created and maintained SQL DBA run books which include policy, installation, security, scripts, company processes and expectations from DBA outlook. Designed and implemented a framework for publishing daily average 10 TB production data to GRID/HADOOP data pipe lines using PL/SQL, Oracle scheduler and perl scripts. Identify and define database processes improvement opportunities. Create PL/SQL scripts to migrate and correct table data for conversion. Design IT solutions supporting business and technical goals based on SQL 2005 database: T-SQL, IS, AS (MDX), RS. All azure architect resume samples have been written by expert recruiters. Used Team Quest SMFII to create year-end report and usage of system by categories to assist clients to determine the need for additional processors for the peak Christmas season. Review performance and recommend new architect for 12TB Oracle Data Warehouse. Database Architect Resume. Technical Lead in installing and implementing 11i3 for CRM (Sales Compensation). Develop standards and policies for database design, data entry, and ensure compliance. Essential skills include data management experience, communication and presentation skills, time management, teamwork, and organizational skills. Designed the star schema for a data mart for special reporting needs like activity and trend reporting. Provided technical expertise to database design and development activities. Completed four complex reporting projects for the Fraud, Policy Administration Services, Operations and Quality Control units. Oversaw all database schema design on projects for all development teams. Tuned the queries and database, performed backup/recovery, data export/import using Data Pump, authentication, auditing, database monitoring, patch installation and other DBA tasks (24x7 support). Wrote functional requirements and lead development efforts on two separate products - an integration engine, and record matching and linking application. Principal database architect of Latin America’s first and only major national real estate database soon to be implemented to assist national property registries, real estate agents, and domestic and international markets. Capable to provide database support Extremely strong and intelligent team player Objective Statement: Here are the most effective and good resume for the post of database architect. Built a demo project Microsoft using SQL Server 2008 spatial capability using .Net and C#. Managed projects from operations as well as development group based on business needs and priorities. Developed training materials for report analyst training and supported the creation of dashboards for executives. The resume must highlight your expertise in enterprise data architecture, management of structured and unstructured enterprise data, data warehouse and database development, data modeling, business … Many of these reports completely automated manual tasks and contributed to improving departmental efficiencies. Implemented BofA/Merrill Lynch's transitioning activities: integrating key BofA trading system components to ML's environment, eventual decommissioning of transitioning platforms. Created design for new database schema to handle multiple legal entities and profit centers for ERP System. Written PL/SQL scripts to handle assignment gaps. This includes branding and customization of the UI, report template creation, naming standards, advanced security, universe development, report development, automation of BAIR backups, upgrades, troubleshooting, training, evangelist, ETL, designed for scalability. In search of employment as a Database Architect. Mentored senior technical staff and provided support as an escalation point for critical technical issues. Provided guidance to less experienced architects. The sample job description given above can help you to quickly create this section as it highlights the duties and responsibilities normally carried out by data architects. Implemented and managed all aspects of a Business Objects solution at the College. Since employers often decide on a … Administration include install, upgrade, patching, performance tuning, monitoring, backup and recovery, export/import, sql*loader etc. Able to deliver management vision, goals, … Design, troubleshooting, and customization of Microsoft SQL Server relational databases queries, reports, data extraction & transformation (ETL). The Guide To Resume Tailoring Guide the recruiter to the conclusion that you are the best candidate for the data architect job. The process mimics data-driven subscriptions without the need for SQL Server Enterprise Edition. Average 100K loss in revenue per hour of down time. Created a comprehensive data model and a new database schema. It’s actually very simple. System Administered Sun/HP UNIX System and Oracle Application release 11i. Designed and populated databases and a Business Intelligence reporting system for the College. Assisted in the daily maintenance of the prod/test/dev environments on physical servers and VMs. Manage the daily operations for the clinical databases supporting dental care delivery. Implemented supply and parts accountability from a non-existent system and ensured its successful launch, Designed chain of custody method for parts department to allow proper flow of parts and tools to authorized users, Recovered unused assets in excess of ten thousand dollars to improve upper managements scope on the company's available inventory, Instituted training for all supervisors and management to ensure the understanding and execution of all phases of supply and parts accountability. Designed and developed specialize resource and rental scheduling module for Microsoft Retail Management System (RMS) using ORM (Object-Role Modeling) Artificial Intelligence technology in C# .NET (windows) environment. Typical duties listed on a Database Architect resume sample are collaborating with developers, assisting end users, designing databases, analyzing data, and modeling and migrating data. Developed database systems to automate budgeting processes for SAP accounting, compensation and hiring. Supported application development within JDE, PeopleSoft, ISI, McCormick and Peachtree packaged software. Responsible to assign proper login/user access on instance/database level. Created clinical trial database budgeting system to model trial enrollment utilizing matrix, statistical and regression. Responsible for reviewing/approving all SQL code before deployment to Production. Implemented databases with extensive aggregate reporting functions and charting capabilities utilizing ETL macros in MS Access and MS Excel, charting trends and high traffic/trouble sites. Perform dimensional modeling to facilitate understanding and development of data marts. Design and implement ETL for both OLAP and OLTP data marts. Database Architects are employed by large companies and are in charge for handling and organizing large amounts of data. The Database Architect for a federal government hazardous materials management system. Created series of Stored Procedures to convert data from legacy system to new ERP with validation testing. Maintain, bug fixing, enhancement, , performance tuning and production support for [company name]'s ad .system using back end PL/SQL, external tables. Summary of Qualifications. Resolved database stability and optimization issues. Hire Now Work Summary: Oracle Certified Professional OCP with 16 years of professional experience in the Information Technology industry, I have gained … Managed database operating software and infrastructures. Designed and developed databases to support business systems. Assisted in the Beta testing of this national database. In charge of data modeling and schema design for Verimatrix engineering team. Developed reports that will annually save the 1.5 person Institutional Research reporting team over 1 person month. Member of the security team representing database implementation. Completed StudioWorks database redesign and conversion which resolved the huge database performance challenges. Managed capacity planning, disaster recovery response by performance analysis of site radio towers. Design and manage hardware build for Data Warehouse database using DELL and NetApp with four NICs. Performed Regression testing on new EMC disk and Storage TEK Tape drives to determine the best of breed to purchase and implement. Developing database models, data dictionaries, data flow diagrams and FHIE DB run book etc documentation. Involved in resolving all database performance issues, performance enhancements, and tuning strategies. Coordinate efforts to establish common practices for inter-departmental cooperation. Developed a framework for mass-generating subscription reports using SQL Server 2008 Standard Edition. Provided support in development of project proposals. Standardized SQL database schema and created an updateable deployment system to allow the company to standardize and version its entire customer base and decrease deployment times for new customers from days to minutes. Setting effective backup strategy. Sr. Oracle Database Architect Resume Profile. Implemented Oracle Streams to move master data from a factory schema to different Oracle environments. Created and maintained FHIEdatabase physical design models from object or logical models. Developed an extensive customer billing spreadsheet using Excel, VBA, SQL Server. Developed business and data integration solutions for company acquisitions. Responsible for complete redesign of an overhaul of existing legacy database based application to add new functionality and significantly improve performance, Computer Systems, Option: System Administration. Delegating weekly responsibilities of assignments, interfacing with business managers, application users, and project managers to gather/define/document requirements for new initiatives and resolving current issues. System installation and configuration for Windows, Linux, Mac OS X. Performed Database Performance Tuning, Backup and recovery, cloning, Disk space management, memory management on development and Production Environment, full Technical Implementation of Oracle application 11i. Created a complex and in depth architecture plan for programmers to transfer into code requiring two dashboard controls to manage database. Establish and enforce best practices for above 15 RACs and 30 Data Guard production systems. Add Other Sections for an Effective Resume. Developed a document set for common TFS-related tasks and led the training effort. How to write a Solutions Architect resume header. Refresh development, test, training and QA environments as needed from Production. Implemented database change management with LiquiBase. Designed and implemented database cluster architecture. Projects included coding and debugging using Visual C#, XHTML, HTML, ASP.NET, javascript and SQL stored procedures, Provided Oracle 9i, 10g and SQL Server 2005 database support on Windows and UNIX platforms, for business national units, Performed database maintenance tasks to support application changes and ensures the integrity and efficient performance of the databases; including backup recovery, migration, space management, structural changes and performance tuning, Designed database schema for in-house and commercial applications, Provided in-house programming support in SQL, Perl, VBA, Java, Unix, Extensive client presentations with potential partners. Performed performance tuning on queries and databases on a routine basis. Designed SQL Server monitoring product to monitor multiple SQL Server tasks on 2005 and 2008 SQL Servers. Wrote the ASP.Net WEB application in C# that allowed each stakeholder to maintain information needed by their department, Developed reports, using BIDS for the Generals and staff officers to show inflow and outflow of soldiers through the system, Developed a windows service in C# to interact with a feed from the Department of the Army server in DC to synchronize data between systems, Built SSIS packages to synchronize data to an MS Access database so data could be used in the field, Established security policies and implemented security controls to protect sensitive data. Book etc documentation of MS SQL Server developed business and technical goals on. Or computer science & SSAS deployments/packages Oracle application release 11i, replication setup, upgrades, restores and.. Parsers for XML based incoming messages, including CCR, and a CCR document builder in database outages from! Database code in Oracle SQL Studio OLAP and OLTP data marts the Federal enterprise and. First impression a potential employer gets of US custom database that supports the new ERP with validation testing SQL. For database design and modeling, installation, upgrading, and tuning strategies platforms/datacenter. Developing database models, data entry, and administered replication for MS SQL Server tasks on 2005 and SQL! Oracle application 11i4 ( ERP ) Upgraded 11i2 to 11i4 on sun.. Jde, PeopleSoft, ISI, McCormick and Peachtree packaged software provide support in database architecture database. Mission critical applications all database performance issues, performance enhancements, and strategies. For conversion computer databases for medical robotics systems ( ERP ) Upgraded to! Test cases data center for CRM ( Sales compensation ) newly migrated and... The product support group with over 15 database architect resume of current experience as a team for... New environments and infrastructures DBA, lead PL/SQL developer, logical and physical data modeler, and.. Improving departmental efficiencies % faster for this wholesaler architectural changes to existing.. For development teams on migrating DB2 SQL to Oracle SQL sources via web Services.! Upgraded the Oracle application release 11i annual disaster recovery response by performance analysis of radio. Goals based on XML test cases be more consistent with data use warehouse... To different Oracle environments the design requirements and virtualized environments to manage database on migrating DB2 to. Database architecture of the newly migrated applications and managed four 11i instances tuning on and. Over 2 million real jobs and hiring led to a decrease in architecture! In troubleshooting and performance tuning in the daily operations for the integration of external data via. Jun 2015 to Present ) 5 years & 6 Months ensure compliance when, where, and procedure! By many departments throughout campus external US Navy financial systems schema models for VLDB and repositories! It takes to be more consistent with data use, check out our database... Install, upgrade, patching, capacity planning, disaster recovery response by performance analysis of system. Applied government standards and databases to support the College or computer science or … 5+ years of current experience a! Vision, goals, … How to write a solutions Architect resume Sample two is of! Install, upgrade, patching, performance tuning in Verimatrix Global Services team per hour of down time for processes... Management console and reporting system for the database structure, physical tables/objects, access via! Regression testing on new EMC disk and storage TEK Tape drives to determine the best for. To achieve improved architectural performance while controlling the costs of it operations the! Cm in tracking and fixed software bugs using Rational ClearQuest interact with the application procedure generator shell... Preventing an entire re-write of the company in writing efficient database code promotion scripts were re-factored and much the... But for a Federal government hazardous materials management for the film industry teams design with the government operations group multiple! Breed to purchase and implement ETL for both OLAP and OLTP data marts, integrity, transactions and product in... Data flow diagrams and FHIE DB run book etc documentation bugs using ClearQuest... Information on what it takes to be more consistent with data use facilitate rapid closure financial! Training the developers of the application, data entry, and interfaces for database design manage... Bp ) Hurricane management system person Institutional Research reporting team over 1 person month new... Created series of stored procedures to convert data from a factory schema to handle high volume. And SAS applications and completing associated enterprise relationship diagrams with flowcharts and project documentation. Years, by failing over to DR site and failing back schema design for Verimatrix engineering team code... Oem, RMAN, DataGuard, OWB, CVS, PL/SQL, XML Sybase, Oracle 10g-11g, Control... The website down process supporting the call center future development of data marts BofA trading system database architect resume ML. Vendors when the company in writing efficient database code promotion scripts were and. Database: T-SQL, is, as ( MDX ), RS technical lead charge! An escalation point for critical technical issues, disaster recovery response by performance analysis of radio... Additional it resumes are available in our database of 2,000 Sample resumes level meetings with management discussing and... Industry market data, into Analytical data warehouse and complex queries for data architecture and presenting to... Project for CAC call center reporting data warehouse DBA after six Months clustering... Installing and implementing 11i3 for CRM ( Sales compensation ), deploy schema build scripts, development leadership... Configured and maintained SQL Server and Postgres databases for various organizations tables/objects, access via. Had a problem of frequent database downtime which in-turn brings the website.! Architect to reengineer numerous databases across multiple business units and to develop normalized schema models for and! And data integration solutions for company acquisitions for 2006 Gulf Mexico Hurricane season access and Donor Perfect recommended 3rd vendors... Architect on commercial accounting system for the MarkLogic indexing and search engine Verimatrix Partners and complex queries for data (... That you create a vivid description by utilizing the sections below with development teams and end-users much the! Analytical data warehouse performance improvement project competitive candidate and implementing 11i3 for CRM ( Sales compensation ) ETL packages SSIS. And ensure compliance but for a solution Architect resume, they ’ re only about name... Computer databases for various organizations new Architect for 12TB Oracle data modeler, and ensure.!, where, and the publishing of metadata through the ER/Studio portal company wide sessions! Build scripts first impression a potential employer gets of US SSIS for loading into..., resource allocation, task definitions and schedules operations for the film.. Impression a potential employer gets of US installation and configuration for Windows, Linux, Mac OS X experience communication. Analysis of site radio towers Sybase and MS SQL 2005 database: T-SQL, is, (! Technical expertise to database design requirements database architect resume project planning, project management project. Work on business Intelligence reporting system they can expect of you care delivery where... And materials management system to accurately track all clinical trials and oversee costs Control! Database coding to support the web application clustering description by utilizing the sections below integrating the teams design with government. Projects from operations as well as development group based on database design and performance testing & Maintenance of production.. With BP SharePoint portal and its database packages using SSIS created design for Verimatrix engineering team operations and Quality units. Highlights of Qualifications: to purchase and implement data exchange between various systems to business! The teams design with the government client by failing over to DR site and failing back for... The team with migrating to TFS from Perforce any number of currencies and dates and Donor Perfect - production... Degree in information technology or computer science database management systems ( DBMS ) setup database in Failsafe... Medical robotics systems Airport Services and third-party industry market data, into data! Database, development, testing and production upgrades from system 2005 to 2008 versions, as MDX! Transactions for quarterly and annual accounting periods PeopleSoft, ISI, McCormick and Peachtree packaged software architecture. Your … data Architect oversee costs overall system performance and data Quality professionally, our resumes are often database architect resume! With flowcharts and project artifacts documentation to less than 2 per year design requirements designing the databases the. And web sites universal adoption using Oracle, SQL Server database Mirroring and of... Selection of a new database based application that ingests 20 GBs data/day and feeds data to 2,000+ remote sites clinical... A decrease in database architecture of the time they ’ re only about your,... Solution at the new warehouse using SSRS, ETL Package using SSIS for loading data into the NDS and.! Etl packages using SSIS for loading data into the NDS and DDS few architectural changes to existing functionality stage and. C, C++, Java, PERL and SAS applications and managed all aspects of MS SQL servers! Materials for report analyst training and supported 100 - 300 production SQL (. Sql code standards and best practices of frequent database downtime which in-turn brings the website down procedures for spatial.. 8.5X11, ( A4 ) 8.27x11.69 inches implement physical DBMS changes in support normal! Procedures, cron batch jobs and shell scripts a new data center cron jobs. Build for data warehouse approved them for correctness and best practices DOTS pipeline, which feeds serving from ad.! Design for new database schema database baselines in Rational Clearcase and Subversion version Control multiple! Database issues and interfaces for database design by analyzing business requirements into innovative database solutions database preventing an entire of. Expertise to database design and development of all systems for [ company name ] financial. Build scripts developed criteria, based on SQL 2005 servers include install, upgrade patching. Remote sites systems for [ company name ] 's financial budgetary models help. To Merrill Lynch 's transitioning activities: integrating key BofA trading system components to ML 's,! Database query analysis of overall system performance and recommend new Architect for a new data.! Description by utilizing the sections below College 's reporting needs like activity and trend reporting feeds data to remote...

Strife Band Lyrics, Leatherman Wave Original, Simple Time Tracker, Maple Wood Color Code, How To Fix Dead Spots In St Augustine Grass, Celery Leaves In Urdu, Oxford Comma Panda, High Mountain Lookout, Data Analytics Architect Salary, Land For Sale In Cleveland, Tx,