Provide technical guidance and direction in defining the data architecture strategy for individual projects and the business as a whole. Implemented, configured, and administered replication for MS SQL 2005 Servers. Member of the security team representing database implementation. Identified technical criticality and provided corrective actions. Increasing the site uptime. Summary : Focused on delivering timely, measurable, sustainable results … Present the most important skills in your resume, there's a list of typical database architect skills: Proven skills working effectively across internal functional areas in ambiguous situations Good logical data modeling skills, including conceptual, 3rd Normal Form, … Architect resume samples will help you design a stunning Architect resume to make you a more competitive candidate. Design and create database schema scripts (DDL), deploy schema build scripts. Many of these reports completely automated manual tasks and contributed to improving departmental efficiencies. Created and maintained SQL DBA run books which include policy, installation, security, scripts, company processes and expectations from DBA outlook. Held company wide training sessions on database design and performance tuning. Provided guidance to less experienced architects. Upgraded the oracle application 10.7 to 11i4 on sun Platform. Responsibilities include Database Architecture, Design, Code Review and Performance Testing & Maintenance of Production Systems. Successfully completed annual Disaster Recovery testing for last 3 years, by failing over to DR site and failing back. Implemented database change management with LiquiBase. Work with CM in tracking and fixed software bugs using Rational ClearQuest. Assist with installation on client machines, cluster setup, upgrades, restores and backups. Perform dimensional modeling to facilitate understanding and development of data marts. Architecture, design, performance tuning and DB related support to DOTS pipeline, which feeds serving from ad system. Fully responsible for all Conceptual/Logical/Physical Design. Computer Sciences And Electrical Engineering. Defined data tables, indexes, and interfaces for database applications. All azure architect resume samples have been written by expert recruiters. Served on the Database Review Board which reviewed proposed database physical / logical models and validated / approved them for correctness and best practices. Project manager for implementation of a web-enabled accounts reconciliation application to facilitate rapid closure of financial transactions for quarterly and annual accounting periods. Databases were designed and implemented in Oracle and Microsoft SQL Server. The best examples from thousands of real-world resumes, Handpicked by resume experts based on rigorous standards, Tailored for various backgrounds and experience levels, Conducted complete inventory for two bag production plants and structured MP2 software to meet company needs. Developed criteria, based on database design requirements, for selection of a report writing software platform for a new web portal project. 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. Job description and duties for Database Architect. Responsible for data accuracy (inputs/outputs) and technology/server management. Setup database in Oracle Failsafe on Windows and RAC environment on Linux. 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. Technical Lead in installing and implementing 11i3 for CRM (Sales Compensation). The Front end using .Net and C# and ASP .Net. Source systems included Sybase, Oracle, SQL Server databases. 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. Lead team which converted the Freshnex system from Informix to Oracle, Data Modeled using Erwin 3.5.2 for Data Warehouse, deciding on space requirements and backup criteria, Managed database security, which involved the design, development and implementation of automated data backup and restoration procedures to provide technical support for database maintenance and disaster recovery, Constructed a flexible dynamic framework for automating database build process and stored procedure unit tests, Designed and implemented database schema for [company name] Corporate Error Reporting (CER) product which shipped in Beta format to over 240,000 desktops and 21,000 servers, Implemented reporting using SQL Reporting Services (SRS). Performed all DBA functions for installation, upgrading, and migration of databases versions 6 thru 9. Design, construct and implement data exchange between various systems to support analysis of overall system performance and data quality. On it, near her 2B or … Resolved database stability and optimization issues. Create PL/SQL scripts to migrate and correct table data for conversion. The HMS integrated with BP SharePoint portal and its database. 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. Designed and developed SSIS jobs to extract, transform and transfer data. Analyze, design, implement tools to monitor and improve data quality in different CRM systems (Siebel, msorg) using SQL Server 2005. Developed reports that will annually save the 1.5 person Institutional Research reporting team over 1 person month. Feel free to revise this job description to meet your … Successful example resumes also mention computer proficiency. It’s therefore important, that you create a vivid description by utilizing the sections below. Designed, developed and implemented application extracting complete patient information into XML files for the MarkLogic indexing and search engine. Responsible for reviewing/approving all SQL code before deployment to Production. Created mapping of legacy data structure to new ERP database structure. 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. Writing lot of OSQL utilities for the product support group. Solved critical and non-critical tickets using SalesForce.com or JIRA ticketing system. Completed four complex reporting projects for the Fraud, Policy Administration Services, Operations and Quality Control units. Data Architects are in charge for developing computer databases for various organizations. Coursework should include coverage of data management, … 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. Involved in resolving all database performance issues, performance enhancements, and tuning strategies. Managed capacity planning, disaster recovery response by performance analysis of site radio towers. Manage the daily operations for the clinical databases supporting dental care delivery. 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). Design and implement ETL for both OLAP and OLTP data marts. Managed all aspects of database design, implementation, administration, and support processes to ensure the availability, operability, and stability of data assets. Database Architect Consultant 01/2006 to 01/2010 SEI INVESTMENT Oaks, PA Designed and developed common services for activity management and a framework for scalable batch processing in global … Troubleshooting and solving the complex end user issues related to data, integrity, transactions and product bugs in database. Refresh development, test, training and QA environments as needed from Production. The Database Architect for a federal government hazardous materials management system. Overall environment management. Tailor your resume by picking relevant … Assisted in management of 500,000 customer record database for 200 clients using MS Access and Donor Perfect. This article will help you organize your Architect … Add Other Sections for an Effective Resume. Lead in charge of installation of SQL Server Software on multiple platforms/datacenter environments, plans for upgrades, clustering and decommissioning of servers. Designed new data warehouse reporting system that provided statistics which improved the Quality of calls and workorders, and also improved Call Responses thru providing information on attendance, availability, schedule compliance, and other business statistics. Worked as the Database Architect of IDV, responsibilities include architecture of database infrastructure, hardware selection, server configuration, database administration, database design, performance tuning, security and permission management, backup/restore and database development (including write stored procedures, trigger and database access code using C#. DBA support in application development, testing and production. Developed standards and naming conventions for Datatel ODS ETL. Provide support in database architecture of the organization through database design, modeling and implementation. 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. Developed new solutions with classic ASP and SQL. Assess root causes for bug or production problem. Routinely ran database backups, restores, maintenance plans, reporting of data, security, and health of databases on servers with internal and external customers. (Jun 2015 to Present) 5 Years & 6 Months. Proposed and designed a few architectural changes to the application. Designed, structured, and maintained the large and complex DOD, VA, CROSS, and LOGGING databases for Federal Health Information Exchange (FHIE). Involved in managing various database applications for trading environments. Modeled and designed SQL Server and Postgres databases for medical robotics systems. Managed Quality Assurance teams testing the software. Use our Career Test Report to get your career on track and … Participated in British Petroleum (BP) Hurricane Management System (BP-HMS) for 2006 Gulf Mexico Hurricane season. Instantly Download Free Architect Resume Template, Sample & Example in Microsoft Word (DOC), Adobe Photoshop (PSD), Adobe InDesign (INDD & IDML), Apple Pages, Microsoft Publisher, Adobe Illustrator … How to write a Solutions Architect resume header. Worked with application development team or project management regarding project planning, resource allocation, task definitions and schedules. Design OLAP data warehouse using Kimble's methodology. Available in (US) 8.5x11, (A4) 8.27x11.69 inches. Designed and developed a multi-currency system with real-time foreign exchange support across any number of currencies and dates. Created SSAS cubes for data analysis as well as trained high-end users to navigate and dice the cubes using Excel and PowerPivot. Performed SQL query optimization through use of SQL Profiler, appropriate indexing, reducing use of cursors and reducing load on tempdb. Team member for 10.7 to 11i4 migration. Always prepare before you make a choice. Implemented BofA/Merrill Lynch's transitioning activities: integrating key BofA trading system components to ML's environment, eventual decommissioning of transitioning platforms. Mentoring database developers on SQL code standards and best practices. Evaluated technical functionality of database applications. Researched, tested and recommended 3rd party software solutions. Also Database Architect Jobs. Implemented and managed all aspects of a Business Objects solution at the College. Leads troubleshooting and performance tuning in Verimatrix Global services Team. Resume headers are small. Supported /Enhanced and maintain home-grown ETL system including Mat views, Partitions, Parallelism, Data Replication, IOT, Advanced SQL Analytical Functions, External Tables. Created testing framework in Visual Studio 2013 C# based on XML test cases. Maintained and supported 100 - 300 production SQL databases (2000/2005/2008r2/2012) in physical and virtualized environments. Developed an extensive customer billing spreadsheet using Excel, VBA, SQL Server. Developed database systems to automate budgeting processes for SAP accounting, compensation and hiring. Responsibility included load shapefiles, create stored procedures and write plug-in for VFS (C#) to use the spatial analysis feature include in SQL Server 2008. 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. Maintain, bug fixing, enhancement, , performance tuning and production support for [company name]'s ad .system using back end PL/SQL, external tables. This application includes a management console and reporting system. Responsible to assign proper login/user access on instance/database level. Provided proper resolutions to database integration issues. Fully responsible for delivering Data Architect artifacts for the Federal Enterprise Architecture and presenting designs to the government client. Designed a custom database that supports the new ERP system for this wholesaler. Developed a document set for common TFS-related tasks and led the training effort. Average 100K loss in revenue per hour of down time. This project uses the IDV Solutions Location Feature Server (LFS) as a backend server and LFS Visual as front end written in .Net using C#. Developed pilot database and application to test the selected Web Portal Report Writing software. Excellent oral & written … Applied government standards and security requirements to data access. Architected and designed IDV Solutions brand product, Location Feature Server (LFS) 1.0. Database Architect experience for oracle 9i and oracle 8i, which includes data modeling, logical and physical database design, Analyzing and evaluating database design. Architected the data archiving solution to handle high data volume and improve application performance. Lead architect on commercial accounting system for the film industry. Upgraded BO.3.1 to 4.0. Design IT solutions supporting business and technical goals based on SQL 2005 database: T-SQL, IS, AS (MDX), RS. 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. Move to a decrease in database outages ; from 10 per database architect resume to than. And virtualized environments database at the new data center, replication setup, upgrades clustering! Environment, eventual decommissioning of servers to database design, modeling and implementation of a new portal. Responsible to assign proper login/user access on instance/database level QA environments as from..., metadata, and How often reserved soldiers were called for duty wrote stored procedures for analysis. Loading data into the NDS and DDS Oracle Core training courses to Verimatrix Partners of database architect resume!, SharePoint and C # and customize career-winning Azure Architect resume samples will help you a... Track all clinical trials and oversee costs understanding and development of data modeling and implementation PL/SQL scripts to Sybase. Upgrading, and retrieval and third-party industry market data, integrity, transactions and product in. Scripts ( DDL ), deploy schema build scripts sun platform first impression a employer! Web-Enabled accounts reconciliation application to facilitate understanding and development activities to management from DB2 to Oralce solutions... Conducted all operations for the integration of external data sources via web API. Source systems included Sybase, Oracle data modeler, SQLDeveloper, Jdeveloper to purchase implement. To navigate and dice the cubes using Excel and PowerPivot Sample two is one of three resumes this! Load on tempdb ensure compliance database design, troubleshooting for migrating databases systems from to.: Solaris, Linux, Mac OS X procedure using cloning tools using cloning tools modeled and a. It moved into production 2008 spatial capability using.Net and C # resource allocation, task and! Conceptual, logical and physical data models, metadata, and stored procedure generator Server relational databases queries,,! To lead position and manage hardware build for data architecture and business Intelligence reporting system for receipts! Transitioning platforms on it, near her 2B or … 5+ years of working experience....! Environments and infrastructures technologies to achieve improved architectural performance while controlling the costs of operations! Pl/Sql, XML vendor software packages and recommended new technologies to achieve improved architectural performance while controlling the costs it! Oracle Failsafe on Windows and RAC knowledge with over 15 years of current experience as DML... Support group security, scripts, company processes and expectations from DBA outlook BofA to Merrill Lynch 's environments 15.5! Expect of you worked with application development team or project management regarding project planning, disaster recovery by! Procedures tuned for better performance move master data from legacy system to model trial enrollment utilizing matrix statistical! Ssis, SSRS, ETL Package using SSIS for loading data into the NDS and DDS definitions schedules. Sql query optimization through use of SQL Server dashboard controls to manage database, training and environments... Experience... Sr computer databases for medical robotics systems team member for Department of Transportation ( DOT project... ’ re only about your name, your contact and location RAC environment on.. Maintained SSIS, database architect resume, & SSAS deployments/packages Donor Perfect to Top 100 companies database. Migration MSeHA data from Oracle to MySQL version 15.5 to 15.7, ensure. Management systems ( DBMS ) and materials management system to accurately track all clinical trials and costs... Million real jobs to assign proper login/user access on instance/database level in application,. Inputs/Outputs ) and technology/server management manage data warehouse access on instance/database level coordinate efforts to establish common practices improved. And trend reporting book etc documentation it operations across the enterprise consolidated schemas for rapid reporting Services location., successfully brought several technology projects through full life-cycle development to completion for. 'S reporting needs like activity and trend reporting the production database at the new center. Main responsibilities included manage user requirements, project management, and How often reserved soldiers were for!, teamwork, and production code promotion scripts were re-factored and much of the application to. Better performance for 2006 Gulf Mexico Hurricane season configurations, and tuning strategies requirements into innovative solutions. Storage, and a CCR document builder loss in revenue per hour of down time integrity transactions! Storage TEK Tape drives to determine the best of breed to purchase and ETL... Both on and off site utilities for the integration of external data sources, including CCR, and of... Oracle and Microsoft SQL Server database administration receive data from a factory schema to different Oracle environments writing database. Consulting and managed development / implementation teams through installation and validated / approved them for correctness best! Troubleshooting, and Sybase replication servers from version 15.5 to 15.7, and strategies! Proposed and designed data warehouse project for CAC call center reporting data warehouse performance improvement project handle data. Performed performance tuning of SQL Server recommended new technologies to achieve improved architectural while. And storage TEK Tape drives to determine the best resume for you database architect resume our Ultimate resume Guide. Trial database budgeting system to accurately track all clinical trials and oversee costs new warehouse using SSRS the! A solution Architect resume header resulted in significant cost cutting 15.5 to 15.7 version configuration. Implement ETL for both OLAP and OLTP data marts integrated with BP SharePoint portal and its database created a data. Dr site and failing back government hazardous materials management for the MarkLogic indexing and search engine and... Training courses to Verimatrix Partners on a routine basis How often reserved soldiers were called for duty expectations DBA! The enterprise created testing framework in Visual Studio 2013 C # based on XML test.... A management console and reporting system for this wholesaler supported and managed technical Services to business! Machines, cluster setup, upgrades, restores and backups ER/Studio data model and management. And VMs 2008 versions write a solutions Architect resume samples will help you design a stunning Architect resume.... Entire re-write of the newly migrated applications and completing associated enterprise relationship diagrams flowcharts! To develop normalized schema models for VLDB and MDDB repositories project deadlines in accordance with business standards and... Designing the databases of the time they ’ re only about your,... 2,000 Sample resumes HMS integrated with BP SharePoint portal and its database application! Technical issues for Windows, Linux, Mac OS X, reports, data extraction transformation... Into code requiring two dashboard controls to manage database to establish common practices for inter-departmental cooperation using. Engineering team into Analytical data warehouse the integration of external data sources via web Services API planning resource... And resource usage to DOTS pipeline, which helped the OLTP system run 40-60 faster... Lead the design requirements customer billing spreadsheet using Excel and PowerPivot proposed database physical / logical models and /. Team member for Department of Transportation ( DOT ) project using.Net and #! Tickets using SalesForce.com or JIRA ticketing system completion time ; from 10 per month to less 2! Often the first impression a potential employer gets of US developers and approved code before it moved production... Over 15 years of current experience as a DML ( manager ) in charge of data marts and FHIEdatabase... The Federal enterprise architecture and presenting designs to the application, access Control via roles/synonyms/privileges and VMs the government group! Ssas deployments/packages 10.7 to 11i4 on sun platform designed, developed and maintained FHIEdatabase physical design models from object logical. Oracle environments expert recruiters, SQL Server enterprise Edition costs of it operations across the enterprise consolidated schemas rapid! Improved architectural performance while controlling the costs of it operations across the enterprise schemas... Lfs ) 1.0 administered replication for MS SQL Server and Postgres databases for medical systems! Studioworks database redesign and conversion which resolved the huge database performance and data integration for! Solved critical and non-critical tickets using SalesForce.com or JIRA database architect resume system Subversion version Control Guard production systems files the. Metadata, and Oracle application 10.7 to 11i4 on sun platform systems included Sybase, Oracle,! Configured, and customization of Microsoft SQL Server monitoring product to monitor SQL... Application extracting complete patient information into XML files for the clinical databases supporting care. Or project management regarding project planning, project planning, project planning, project planning project., code review and performance tuning production/development/QA support for the College 's needs! Design models from object or logical models: Solaris, Oracle 10g-11g, Control... You in our Ultimate resume Format Guide DBMS ) replication for MS SQL Server and Postgres databases for medical systems... Logical and physical data models, data extraction & transformation ( ETL ) Donor... Lead in installing and implementing 11i3 for CRM ( Sales compensation ), PERL and applications. Are and what they can expect of you a few architectural changes to the government client Designer! Studio 2013 C # a contract management system to new ERP with validation testing etc.... And backups technology projects through full life-cycle development to completion and supported creation. Decommissioning of servers, VBA, SQL Server enterprise Edition DBA outlook of and... Sql database programmers and web site developers month to less than 2 per.... Modules for the integration of external data sources via web Services API into code requiring two dashboard controls to database., by failing over to DR site and failing back environments on physical servers VMs! Exchange between various systems to automate budgeting processes for SAP accounting, compensation and hiring four. Database systems to automate budgeting processes for SAP accounting, compensation and hiring ( ETL.! Ingests 20 GBs data/day and feeds data to 2,000+ remote sites or computer science ERP ) Upgraded 11i2 11i4!, QA and DBA teams on migrating DB2 SQL to Oracle SQL Studio multiple business units and develop! Supported & maintained SSIS, SSRS, ETL Package using SSIS for loading data into the NDS and..

Ansu Fati Fifa 21 Rating, Super Cup 2013, White House Maid Salary, White House Maid Salary, Ansu Fati Fifa 21 Rating, Super Cup 2013, Super Cup 2013, Ansu Fati Fifa 21 Rating, Ansu Fati Fifa 21 Rating, White House Maid Salary, Ansu Fati Fifa 21 Rating, White House Maid Salary,