FIND PERSONALIZED JOBS
Sign up to Zippia and discover your career options with your personalized career search.
Sorry, we can't find that. Please try a different city or state.

Senior Database Architect

This job has expired and is no longer available.
APPLY NOW
Apply Now
×
FIND
PERSONALIZED JOBS

Sorry, we can't find that. Please try a different city or state.

CONTENT HAS
BEEN UNLOCKED
Close this window to view unlocked content
or
find interesting jobs in

Log In

Log In to Save

Sign Up to Save

Sign Up to Dismiss

Sign Up

SIGN UP TO UNLOCK CONTENT

or

The email and password you specified are invalid. Please, try again.

Email and password are mandatory

Forgot Password?

Don't have an account? Sign Up

reset password

Enter your email address and we will send you a link to reset your password.

Back to Log In

Log In

Log In to Save

Sign Up to Save

Sign Up to Dismiss

Sign up to save the job and get personalized job recommendations.

Sign up to dismiss the job and get personalized job recommendations.

or

The email and password you specified are invalid. Please, try again.

Email and password are mandatory

Already have an account? Log in

reset password

Enter your email address and we will send you a link to reset your password.

Back to Log In

Company Saved

Answer a few questions and view jobs at that match your preferences.

Where do you want to work?

Job Saved

See your Saved Jobs now

or

find more interesting jobs in

Job Dismissed

Find better matching jobs in

Your search has been saved!

Top 50 Senior Database Architect Skills

Below we've compiled a list of the most important skills for a Senior Database Architect. We ranked the top skills based on the percentage of Senior Database Architect resumes they appeared on. For example, 9.7% of Senior Database Architect resumes contained Pl/Sql as a skill. Let's find out what skills a Senior Database Architect actually needs in order to be successful in the workplace.

These are the most important skills for a Senior Database Architect:

1. Pl/Sql

demand arrow
high Demand
Here's how Pl/Sql is used in Senior Database Architect jobs:
  • Provide support to the development team for changing the various PL/SQL modules, and deploying these modules to the new infrastructure.
  • Developed a web services package written in PL/SQL that was used to return XML formatted results sets to requesting applications.
  • Develop a framework for financial process and dependent DWH processes to handle backlog gracefully in automated way using Oracle PL/SQL.
  • Create and Review project artifacts such as database design, PL/SQL programs and provide necessary guidance to the team members.
  • Designed and developed PL/SQL packages, procedures, functions, cursors, Materialized Views, user defined object types etc.
  • Design, develop and test Oracle PL/SQL stored procedures, triggers, packages, and functions to maintain data integrity.
  • Develop complicated stored procedures, packages, functions with PL/SQL, and tune the performance of stored procedures.
  • Write complex PL/SQL scripts to update or fallback database changes in a high availability RAC environment.
  • Developed them using both PL/SQL and TSQL for different database environments.
  • Modified existing PL/SQL procedures, packages and triggers.
  • Developed and Implemented within Oracle PL/SQL Packages.
  • Managed Team of 7 PL/SQL developers.
  • Used SQL Server T-SQL and Oracle 10g PL/SQL
  • Assisted in troubleshooting Oracle error codes Coding procedures / functions / triggers for various applications in PL/SQL.

Show More

2. Physical Database Design

demand arrow
high Demand
Here's how Physical Database Design is used in Senior Database Architect jobs:
  • Developed logical and physical database design to include database partitioning.
  • Worked closely with Business Analysts, User Groups, and Developers while I developed the Logical and Physical database designs.
  • Performed Logical and Physical Database Design via LBMS.

Show More

3. Database

demand arrow
high Demand
Here's how Database is used in Senior Database Architect jobs:
  • Revise and improve current monitoring strategies for the entire database enterprise (Introduced and setup SQL Sentry).
  • Adhered to documented change control by raising RFC and perform modifications to databases during weekend windows.
  • Involved in maintenance of roles, database links, directory objects, table partitions etc.
  • Supervised the efforts of database consultants, database administrators, and systems architects.
  • Involved in planning, execution and management of all database related activities.
  • Developed continuous data conversion between AS400 Mainframe Databases and SQL Server.
  • Implemented and tested all database object code.
  • Migrated Mongo database systems from No-SSL authentication to SSL authentication using certificates.
  • Spearhead innovative database design supporting education and healthcare strategic initiatives.
  • Monitor and resolve Database Service incidents within established SLAs.
  • migrated/upgraded multiple database using SHAREPLEX replication tools.
  • Created data interfaces between Web Databases and Third Party Vendors Implemented a customer survey project.
  • Worked as Database SME for database migration from HP PA-RISC server to Itanium server.
  • Carried out POC for cross-platform database cloning (Solaris to Red Hat Linux).
  • Acknowledge and Address database alerts raised by enterprise monitoring tools within established SLAs.
  • Worked as Database SME for datacenter relocation from one site to another site.
  • Enable sharding on databases and collections by choosing suitable shard keys.
  • Migrated Mongo database from MMAPV1 storage engine to WiredTiger storage engine.
  • Handled multiple MYSQL databases for user games utilizing master-slave sharding.
  • Developed Ruby/Python scripts to monitor health of Mongo databases and perform ad-hoc backups using Mongodump and Mongorestore.

Show More

11 Database Jobs

No jobs at selected location

4. SQL

demand arrow
high Demand
Here's how SQL is used in Senior Database Architect jobs:
  • Established stability on SQL Server databases containing MLS data by auditing each database for index integrity and identifying inefficient stored procedures.
  • Installed, configured, and administered development PostgreSQL instances and databases in the development and staging environments.
  • Implemented and maintained maintenance plans, such as backups and database consistency checks, on multiple production SQL Servers.
  • Worked on Oracle Golden Gate to replicate data across heterogeneous databases (from Oracle to SqlServer, MySQL).
  • Mentored database developers in writing elegant Transact-SQL, using the graphical query plans as a teaching tool.
  • Supported over 21 standard and clustered SQL Server instances for all development and production databases.
  • Configured and administered SQL Server instances and databases in the production and staging environments.
  • Designed and executed data center migration for all SQL Systems from Denver to Arizona.
  • Designed upgrade, and migration scenarios for hundreds of production SQL Server systems.
  • Led database team using SQL Server 2000, 2005, and 2008 environments.
  • Upgrade and migrate databases from SQL Server 2000 databases to SQL Server 2005.
  • Configured the PostgreSQL staging environment with primary and hot standby database servers.
  • Provide SQL knowledge sharing to members of project team as required.
  • Migrated remotely-hosted SQL 7.0 database servers to in-house SQL 2000 servers.
  • Optimized SQL and database for faster Query response times.
  • Developed and maintained SQL Servers and their OS systems.
  • Served as part of NoSQL Exploration project.
  • Perform code reviews of all SQL.
  • Addressed auditing deficiencies in source solutions with SQL Server Transactional Replication and Change Data Capture functionality.
  • Recognized for outstanding capacity to demonstrate SQL expertise and partner with key resources to support on-time deliverables.

Show More

10 SQL Jobs

No jobs at selected location

5. Data Warehouse

demand arrow
high Demand
Here's how Data Warehouse is used in Senior Database Architect jobs:
  • Integrated Timberline Construction software package into Data warehouse and developed intelligence for our Construction Team.
  • Define data and technical architectures and technical requirements for the data warehouse.
  • Managed a team of five data warehouse developers/analyst in daily operations.
  • Developed and implemented backup and recovery strategies for corporate Data Warehouse.
  • Work with end users to create a flexible and adaptable Data Warehouse model that will grow as the business grows.
  • Created ETL packages using Microsoft SSIS to transform and integrate several database structures into a single integrated data warehouse.
  • Implemented custom Change Data Capture (CDC) to provide a feed to the Main Data Warehouse.
  • Experience in Delta load for Data warehouse after finish initially process full load using ETL process.
  • Provide production SQL Server evaluation and recommendations for all Campus Door OLTP and data warehouse systems.
  • Developed SSIS DTS and DTSX ETL packages for data warehouse and inter-database data transfers.
  • Provide guidance to software development teams on use and purpose of data warehouses.
  • Develop ETL scripts to load data from OLTP DB to data warehouse DB.
  • Design, Administer, Maintain Data Warehouse environment and SQL Server Reporting Services.
  • Worked on OLAP Data warehouse, Model, Design, and Implementation.
  • Demonstrated to the customer the capabilities of the new data warehouse.
  • Review requirements to Architect Data Warehouse solutions for new projects.
  • Develop and implement Enterprise data warehouse bus Matrix Reports conversion from OLTP to OLAP Database
  • Design and engineer multi-dimensional Claims Data-Warehouse Created SSIS data load packages to load 8 terabyte OLTP system to data warehouse.
  • Adopted Kimball Lifecycle, Bus Architecture & Dimensional Modeling to create a clean and effective Enterprise Data Warehouse.
  • Define meta data standards for the data warehouse Design the information delivery and access for the data warehouse.

Show More

3 Data Warehouse Jobs

No jobs at selected location

Job type you want
Full Time
Part Time
Internship
Temporary

6. Database Architecture

demand arrow
high Demand
Here's how Database Architecture is used in Senior Database Architect jobs:
  • Provided expert knowledge in the selection, provision and use of database architectures, software and facilities.
  • Designed the database architecture for US OPM's modernization project.
  • Team Lead and primary architect for Database Architecture team.

Show More

7 Database Architecture Jobs

No jobs at selected location

7. ETL

demand arrow
high Demand
Here's how ETL is used in Senior Database Architect jobs:
  • Performed ETL (Extraction, Transformation, and Loading) on Operational system data prior to loading into DW.
  • Served as a SSIS subject matter expert in designing data flow of ICD to Support ETL solution.
  • Designed and developed electronic data processing procedures (ETL) and scripts for DOD's DSES project.
  • Researched COTS ETL solutions to accommodate client needs of collecting instruments data from 15 different systems.
  • Developed ETL procedures to import claim, CDM, HCRIS, and reimbursement data.
  • Design and Developed ETL process to source the trade data from various legacy systems.
  • Developed and supported the ETL processes for both the MS SQL and Oracle environments.
  • Identified third party data source data integrity issues and adjust the ETL process accordingly.
  • Assisted the QA/UAT team by providing Database/ETL support during the QA/UAT testing phase.
  • Developed and implemented ETL processes utilizing EasyCASE, SQL, and PL/SQL.
  • Design and implement ETL for both OLAP and OLTP data marts.
  • Direct and design the ETL process involving data quality and testing.
  • Generated specifications for the ETL team to create SSIS packages.
  • Coded ETL routine for daily updates and staging area.
  • Designed and implemented ETL processes and Reporting solutions.
  • Developed and managed datamart that gathered data from numerous sources using various ETL processes employing over fifty job steps daily.
  • Deliver key reporting and auditing process architecture in a very aggressive timeline for the ETL pipeline.
  • Architected and developed MySQL ETL processes for new database warehouses.
  • Maintained the entire deployment process within Dev/QA/UAT for Database/Database objects/ETLs/Reports.
  • Designed many ETL jobs using Informatica as well as Oracle PL/SQL procedures and sql loader features.

Show More

8. DBA

demand arrow
high Demand
Here's how DBA is used in Senior Database Architect jobs:
  • Coordinated periodic deployments with the development DBA and provided architectural feedback to him during the redesign of the application.
  • Customized Abacus system as per the needs of PRM and provided development and DBA support for the client.
  • Serve as system administrator and database administrator (DBA) for the factory's Oracle/Linux servers.
  • Defined the Cost saving structured Shared-Service Model for the operational DBA team servicing multiple projects.
  • Helped DBA group to troubleshoot server non-response issues caused by legacy extended stored procedures.
  • Lead DBA responsible for assigning tasks and supervising 2 other DBA's.
  • Provided direction for 24-hour off-shore production and development DBA staff.
  • Provided operational DBA support for client's servers 24X7.
  • Managed and mentored other DBA to support this project.
  • Perform all standard DBA/DBE tasks.
  • Mentored application developers and DBAs in proper application design relating to relational database design.
  • Worked on Daily DBA tasks involving management of all production, QA, Dev databases of over 28 TB in size.
  • Performed all DBA functions for installation, upgrading, and migration of databases versions 6 thru 9.
  • Played an integral role in accomplishing DMZ configuration for iStore module with reverse proxy and LoadBalancers.
  • Lead and mentor junior DBAs in the team.
  • Manage and support Great Plains/Microsoft Dynamics database system Assist other DBAs and Report developers in writing efficient codes.
  • Project: DBA Managed Service Role/Responsibility: Critical 24X7 Oracle EBS R12 Production Support for Alcoa and Arconic.

Show More

1 DBA Jobs

No jobs at selected location

9. Physical Database Models

demand arrow
high Demand
Here's how Physical Database Models is used in Senior Database Architect jobs:
  • Design logical and physical database models for test and production MS SQL & Oracle environments.

Show More

10. Backup

demand arrow
high Demand
Here's how Backup is used in Senior Database Architect jobs:
  • Performed extensive shell scripting that included collecting security violation reports, SOP violations, monitoring requirements, and backup/ restore requirements.
  • Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
  • Designed and implemented backup/recovery plans and procedures.
  • Developed database jobs used to perform database backup, user metrics generation, database purge and table statistics gathering.
  • Design and lead the implementation of backup, disaster recovery and data archiving solutions for Very Large Database environments.
  • Configure and schedule database backups; create standby databases and install software tools for production and development activities.
  • Developed and implemented custom procedures for database maintenance, backups, and alerting.
  • Installed and configured OPS manager automation, monitoring and backup agent.
  • Orchestrated the design and testing of backup and recovery plan.
  • Served as the primary backup network administrator.
  • Created Nightly backup and maintenance jobs.
  • Designed the automation of data feeds, data validation/verification and full system scheduled backups.
  • Design and implement Teradata backup and recovery solutions using ABU/Net backup/Tara.
  • Optimize Oracle based processes and implement backup strategy using Netbackup.
  • Developed scripts for RMAN backup using cron.
  • Participated in AWAMAR backup solutions for offsite.
  • Develop optimized backup schedules to ensure 100% database recovery Rolled out Database installs and patching automation using BMC Bladelogic database automation
  • Implemented better backup solution to backup Mongo Databases.

Show More

2 Backup Jobs

No jobs at selected location

11. Ssis

demand arrow
high Demand
Here's how Ssis is used in Senior Database Architect jobs:
  • Demonstrated ability to analyze and troubleshoot complex problems * Proactively supported application teams, assisted developers with Oracle issues and questions.
  • Mentored and assisted junior developers and programmer analysts in all areas of systems development and design.
  • Interact with and assist system administrator to provide a compatible and effective database environment.
  • Created SSIS Packages to perform Data-Migration from Sun-set Paradox/Delphi applications to SQL Database.
  • Assist in defining Standards and Guidelines for the projects, build and maintaining the Enterprise Data Model / Dictionary.
  • Assisted Developers in generating different kinds of Reports such as Drill-down, Drill-through, Link, Subscription reports.
  • Developed and implemented Extract, Transform and Loading processes using SQL Server integration Services (SSIS).
  • Developed SSIS Packages for dynamic File formats, Data formats, custom delimiters & FTP.
  • Utilized SSIS data flows with Parallel loads to separate partitions to increase performance.
  • Used SSIS Packages with configurable connection strings to allow cross platform deployment.
  • Create File handler SSIS framework for verification/Alerting of issues with incoming-outgoing files.
  • Design, develop, modify, test, and implement SSIS projects.
  • Assisted in the design, development and implementation of corporate web sites.
  • Developed and Created Integration Services Catalogs to host the SSIS packages.
  • Migrated in data for 200+ customers and provided friendly customer assistance.
  • Created SSIS package to upload data and process the CUBE.
  • Provide ETL recommendations for loading data marts with SSIS.
  • Perform /assist in various software installations and upgrades.
  • Develop C# console applications to enhance and load data coming from data vendors and Bloomberg Terminal where SSIS was insufficient.
  • Assisted Business Analysts in designing some critical Screens, ETLs and Reports.

Show More

12. High Availability

demand arrow
high Demand
Here's how High Availability is used in Senior Database Architect jobs:
  • Tested and successfully implemented Log Shipping or Replication technique for production databases as a High Availability solution.

Show More

3 High Availability Jobs

No jobs at selected location

13. Oltp

demand arrow
high Demand
Here's how Oltp is used in Senior Database Architect jobs:
  • Designed and implemented physical and logical OLTP databases for data mining and web-based applications.
  • Created and configured an OLTP replication database for disaster recovery purpose.
  • Applied the Master Data Management (MDM) Hub Architecture concepts to existing OLTP and DW solutions.
  • Analyze queries, develop and implement index strategies for OLTP systems.
  • Involved in loading the partner flat files into the OLTP database.
  • Design, develop and test a custom OLTP Oracle 8i database to provide back-end functionality for an eCommerce Shopping Cart System.
  • Solved many problems in SQL Server [ ] for high transaction load OLTP systems and large scale DSS database systems.
  • Designed, managed and coded changes yielding 100x increase in scalability of OLTP system.

Show More

3 Oltp Jobs

No jobs at selected location

14. Recovery Procedures

demand arrow
high Demand

15. Capacity Planning

demand arrow
average Demand
Here's how Capacity Planning is used in Senior Database Architect jobs:
  • Perform capacity planning and redundancy considerations for Data contingency plans.
  • Perform Logical and Physical design and Capacity Planning.
  • Perform capacity planning and space management.
  • Performed monitoring and capacity planning.
  • Involved in backup and recovery, capacity planning and routine database maintenance.

Show More

1 Capacity Planning Jobs

No jobs at selected location

16. Linux

demand arrow
average Demand
Here's how Linux is used in Senior Database Architect jobs:
  • Played key role in projects like Data Center migration, Linux migrations and virtualization.

Show More

2 Linux Jobs

No jobs at selected location

17. RAC

demand arrow
average Demand
Here's how RAC is used in Senior Database Architect jobs:
  • Implement and administer Oracle Golden Gate uni-directional replication for reporting purposes.
  • Provide database performance recommendations and security best practices.
  • Raise SR with Oracle Support for different ORA errors raised and co-ordinate with Oracle support to solve the issue.
  • Prepare weekly status reports, track the progress of the assigned projects and present to the client managers.
  • Generated system workload models from application trace data that were used during load and stress tests.
  • Secured critical databases by implementing Oracle Transparent Data Encryption (TDE) on 11g/12c Multi-Tenant databases.
  • Conduct workshops to customers to explain best practices of migration and post migration performance tuning.
  • Develop various Oracle PLSQL package, procedure and Unix shell script as per business requirement.
  • Involved in setup of database table replication using Oracle Materialized view.
  • Implemented best practices catered towards Risk and Compliance, Business Continuity.
  • Created OLAP cube for by extracting the asset management data.
  • Manage Oracle Forms development and database support teams.
  • Negotiated IT contracts with vendors and suppliers.
  • Installed and Configured Oracle EBS R12 (12.1 and 12.2) Systems.
  • Increased application integrity by successfully using the Oracle 8i Logminer utility to identify the source of unknown production data modifications.
  • Have used SQL trace to locate blocking bottlenecks and identify changes to table structures and sprocs to eliminate blocking bottlenecks.
  • Manage contract developers and provide guidance on business logic, and workflow.
  • Enable SQL trace and provide the tkprof output for developer s analysis.
  • Create, Maintain and Clone Oracle 12c Pluggable databases.
  • Configure Oracle dataguard broker, observer process to enable fast-start-failover (FSFO).

Show More

1 RAC Jobs

No jobs at selected location

18. DB

demand arrow
average Demand
Here's how DB is used in Senior Database Architect jobs:
  • Suggested suitable MongoDB Data Modeling techniques for application team.
  • Lead efforts of DBA team in stopping spiral of production environment and stabilize the database environment; leading to business continuity.
  • Involved in troubleshooting of Oracle errors reported by database users and handling any production issues that need DBA intervention.
  • Collaborate with Technical Architects, DBA, Application development teams to arrive at the best Design and Interface approach.
  • Lead the DBA team and responsible for over 200 Production/Non-Production MySQL/MS databases with 100 TB data.
  • Installed Oracle Apex 5.0 and developed application for DBA/Application Infrastructure usage.
  • Interviewed and hired Data Migration Lead and Oracle DBA.
  • Designed RMAN backups to be executed from Standby databases.
  • Establish escalation policies for the db team.
  • Migrated Current DB2/4000 database to Oracle environment.
  • Implemented read preferences in MongoDB replica set.
  • Developed automation utilities for DBA Usage.
  • Carried out Data de-fragmentation, reorganization, Data Security, Data Warehousing using dB management systems.
  • Experience in managing MongoDB environment from availability, performance and scalability perspectives.
  • Worked on MongoDB database concepts such as locking, transactions, indexes, Sharding, replication, schema design.
  • Configured Jetstream for self-service of Oracle Database, EBS R12, MSSQL, DB2 etc.
  • Experience in handling the service requests with MongoDB Jira for resolving issues.
  • Mentored a team of five Oracle and MS SQL Server DBAs.
  • Upgrade databases from [ ] to [ ] using DBUA.
  • Automated Cloning and Virtualization of complete stack including dbTech, appTier and database.

Show More

3 DB Jobs

No jobs at selected location

19. Setup

demand arrow
average Demand
Here's how Setup is used in Senior Database Architect jobs:
  • Assist with installation on client machines, cluster setup, upgrades, restores and backups.
  • Worked on RMAN setup and configuration, RMAN Backup, Duplicating database using RMAN.
  • Created and Setup container and plugged databases.
  • Worked with Client to determine the best Hardware solution and setup to accommodate the Dataware house in the Data Center.
  • Used Inno Setup script driven installation system to create Installer.
  • Worked on setup of DataGuardBroker to automate fast failover.

Show More

20. T-Sql

demand arrow
average Demand
Here's how T-Sql is used in Senior Database Architect jobs:
  • Enhanced T-SQL code and re-designed the indexes to optimize performance of the data retrieving processes.
  • Developed and Implemented Stored Procedures and Functions with SQL Server Transact-SQL (T-SQL).
  • Produced Logical Schema T-SQL Scripts, Tables, Views, and Stored Procedures.
  • Performed data profiling of the source data using T-SQL.
  • Managed Team of 4 T-SQL developers.
  • Worked on Microsoft team foundation server to store ETL packages, proc and T-SQL.
  • Used ERWin Data Modeler, SQL Server and T-SQL.

Show More

21. Unix

demand arrow
average Demand
Here's how Unix is used in Senior Database Architect jobs:
  • Performed database administration on Unix and Windows NT machines with several instances.
  • Key Accomplishments: Database migration from Oracle 10g to Oracle 11g on another OS (Unix to Linux).

Show More

1 Unix Jobs

No jobs at selected location

22. Sybase

demand arrow
average Demand
Here's how Sybase is used in Senior Database Architect jobs:
  • Designed and implemented the Sybase and MySQL database architectures, including but not limited to physical database design, including partitioning.
  • Use SSIS to create Data Extractions to load target databases from multiple data sources including Sybase and Oracle 11g data sources.
  • Administrated & supported multiple development/test Databases on projects to convert from SQL Server and Sybase to Oracle7 and 8.
  • Designed Sybase and MySQL replication architectures with the target to function as a warm standby for the primary.
  • Provided Sybase ASE 12 database support for various production systems at the center.
  • Resolved Sybase internal DB SP issue to re-architecture platform database.
  • Involved in migrating Sybase 12.5 databases to SQL Server 2005.
  • Enabled real-time insight into Sybase database activity and performance by designing and producing a web portal application.
  • Implemented distributed database communication between DB2, Oracle and SYBASE databases using DB2/UDB DataJoiner.
  • Upgraded Informix IDS 10 to Informix IDS 11 and Informix tools I4GL, ISQL, and ESQL/C Administered Sybase 12.5 databases.

Show More

23. C #

demand arrow
average Demand

24. Mysql

demand arrow
average Demand
Here's how Mysql is used in Senior Database Architect jobs:
  • Configured and managed template using RightScale for MYSQL master slave configuration deployment and automation.
  • Maintained real-time MySQL databases, including component updates and new functionality implementations.
  • Perform MYSQL database backup and recovery operation.
  • Worked on MySQL replication, snapshot backup, cloning, performance tuning for version 5.1.50 and 5.5.8.
  • Configured Query Analyzer to monitor MYSQL queries from JAVA application using Connector/J JDBC driver.
  • Set up MySQL cluster and replication environments for development, staging and production.
  • Configured MYSQL enterprise backup for online backup of the MYSQL databases.
  • Supported and tuned databases and queries in MySQL systems.
  • Support MySQL database infrastructure consisting of 2 datacenters with MySQL Server that use master-master with identity offset.
  • Install and migrate data into PostgreSQL and MySQL for visual analytics tools.
  • Design, architect and implement highly scalable and available MySQL database infrastructure Implemented MYSQL enterprise monitor for database and server monitoring.

Show More

25. XML

demand arrow
average Demand
Here's how XML is used in Senior Database Architect jobs:
  • Created testing framework in Visual Studio 2013 C# based on XML test cases.
  • Switched EDI Spec to utilize database driven XML messaging.
  • Use of XML standard record layouts for HR services and SQLXML.
  • Improved, simplified, automated XML files data load process using XQuery language.
  • Experience with Web Service technologies - SOAP, WSDL and XML technology with XSLT, XQuery and XPath expressions.

Show More

26. Solaris

demand arrow
average Demand
Here's how Solaris is used in Senior Database Architect jobs:
  • Worked with NetApp customers for all oracle 10g and 11g migrations from Solarisxx to Linux Oracle VM.
  • Installed Solaris 10 SPARC on SUN Fire T2000 machines to use in a proof of concept.
  • Install and manage Oracle database server 11g, 10g on Solaris 10, and Windows 2003.
  • Worked with the AIX and Solaris Admins to fine tune OS settings per recommendations on Oracle Metalink and SAP OSS notes.
  • Created and configured physical standby Data Guard on Solaris for NCCM, GTMS, OSSCentral production databases.

Show More

27. Ssrs

demand arrow
average Demand
Here's how Ssrs is used in Senior Database Architect jobs:
  • Created summary and details reports using SSRS, deployed them on report server for Users.
  • Converted all financial and inventory reports from Active Report to SSRS.
  • Designed, created complex clinical research reports using SSRS.
  • Managed SSRS implementation for Ad Hoc, Dashboard, and Distributed Reporting for both internal and external partner reporting.

Show More

28. DB2

demand arrow
average Demand
Here's how DB2 is used in Senior Database Architect jobs:
  • Created enterprise data models for three separate development projects in DB2, FoxPro and Oracle.
  • Installed DB2 ESE DPF, High Performance Unload, implemented partitioning and compression.
  • Created a migration plan from FoxPro to DB2.

Show More

29. Perl

demand arrow
average Demand
Here's how Perl is used in Senior Database Architect jobs:
  • Modeled databases for use with ATG Dynamo, Oracle 9iAS, BEA WebLogic, PERL and more.
  • Involved in developing Perl programs to parse and load data from flat files into database.

Show More

1 Perl Jobs

No jobs at selected location

30. BI

demand arrow
low Demand
Here's how BI is used in Senior Database Architect jobs:
  • Recommend hardware architectures, develop backup and recovery strategies, and develop partitioning strategies for improved performance and availability.
  • Designed system for maximum performance and high availability Leveraged core technical internal knowledge to troubleshoot and resolve various problems.
  • Lead performance tuning efforts of existing stored procedures and functions focused on reliability enhancements.
  • Contributed to maintaining database availability at 99.9999999% across all MySQL backed applications.
  • Recommended and implemented a high availability database solution utilizing Oracle Data Guard.
  • Recommended disk configurations that improved database throughout while maintaining high availability.
  • Created numerous Crystal Reports involving drill-downs and numerous advanced capabilities.
  • Utilize enterprise database monitoring tools (OEM) to monitor and resolve database performance and availability issues.
  • Converted secondary node to Arbiter based on requirement to reuse of storage for different application.
  • Designed the physical data models for EDW, and BI presentation layer.
  • Led BI and reporting initiatives for accounting, CRM (Sugar CRM), and ERP (MS Dynamics) systems.
  • Implemented technical strategies to improve database performance and scalability.
  • Increased reliability and scalability of an online image repository by using custom test harnesses to stress test the database interface.
  • Managed all aspects of database design, maintenance, high availability, disaster recovery, development, troubleshooting and tuning.
  • Assisted in setting up star schema for one of the BI application for optimal performance while using Cognos report.
  • Installed and configured Oracle GoldenGate on Solaris 10 for proof of concept of Continues Availability (CA) project.
  • Determine and document stabilization roadmap for the next 5 years based on trends in technology for the company.
  • Improved reliability of several enterprise distributed client/server applications while increasing performance by 10% to 200%.
  • Directed/Applied tasks at SFIA Level 6 on Database Design, Availability Management, Level 5 Database Administration.
  • Led the development of a decision support suite of applications for bank profitability mgmt.

Show More

31. Internet

demand arrow
low Demand
Here's how Internet is used in Senior Database Architect jobs:
  • Managed and Architected numerous information technology projects specializing in electronic commerce, Database and Internet technologies.
  • Designed and developed internet database applications for clients Enhanced the company's web search engine (SRF)
  • Front Porch was an Internet startup that was headquartered in Standard, CA.
  • Designed the majority of the databases for MicroTelco, which won the Best Of Show from Internet Telephony magazine in 2000.
  • access via the internet and intranet.)

Show More

32. SAN

demand arrow
low Demand
Here's how SAN is used in Senior Database Architect jobs:
  • Performed the installation and configuration of Cassandra column-oriented database environments on a Linux (CentOS) platform.
  • Loaded data into Cassandra using Quest Software's Toad for Cloud Databases product.
  • Designed, Constructed SYNON functions and RPG/COBOL programs for the maintenance and enhancements of the Renaissance cruises reservation system.
  • Specified and implemented a new 3Par SAN for the dev and QA data tiers.
  • Architected and designed SAN and NAS solutions for high availability of data.

Show More

33. Rdbms

demand arrow
low Demand
Here's how Rdbms is used in Senior Database Architect jobs:
  • Installed Oracle 12C Grid Infrastructure and RAC RDBMS on a 4 node cluster hosting Red Hat Enterprise Linux 7.
  • Implement the performance rules and algorithms for the Oracle 8i RDBMS when designing the physical data model.
  • Use Oracle 10GR2 RDBMS Tools - OEM, (Oracle grid) to manage Oracle 10g RAC environment.
  • Design advanced ETL methods utilizing RDBMS tools with middle tier tools for optimal ETL across large datasets and environments.
  • Perform and supervise database upgrades for Oracle & MS SQL Server rdbms.
  • Migrated data from RDBMS to Hadoop infrastructure using Sqoop.

Show More

34. Business Requirements

demand arrow
low Demand
Here's how Business Requirements is used in Senior Database Architect jobs:
  • Develop and implement backup/restore, security and audit procedures and security policies to ensure the system meets business requirements.
  • Determined data mart business requirements.
  • Participated in gathering business requirements, analysis, code reviews, testing, release management, pre and post checkout procedures.

Show More

35. Management System

demand arrow
low Demand
Here's how Management System is used in Senior Database Architect jobs:
  • Created the Bay Area Air Quality Management District's Air Quality Data Management System SQL Server database.
  • Re-engineered and migrated the Real Property Asset Management system to web portalapplication.
  • Participated in the upgrade of the firm's document management system (DMS).
  • Supported a Crew Management System using Cold Fusion and SQL Server 7 database.

Show More

36. Olap

demand arrow
low Demand
Here's how Olap is used in Senior Database Architect jobs:
  • People want to see data real-time so ROLAP was used for this part of it.
  • Designed OLAP datamart with automated filespace partitioning for muti-terribyte system.

Show More

37. Mongodb

demand arrow
low Demand
Here's how Mongodb is used in Senior Database Architect jobs:
  • Attended online MongoDB DBA classes and in the process configured replicate sets and shards to distribute the data.

Show More

38. Production Environment

demand arrow
low Demand
Here's how Production Environment is used in Senior Database Architect jobs:
  • Set up robust backup/recovery strategy in production environment.
  • Provided DBA support for financial applications in Development, Testing and Production environments on daily basis.

Show More

39. Hadoop

demand arrow
low Demand
Here's how Hadoop is used in Senior Database Architect jobs:
  • Monitor Hadoop cluster connectivity and security.

Show More

40. Rman

demand arrow
low Demand
Here's how Rman is used in Senior Database Architect jobs:
  • Supported system performance process improvements by actively participating in design reviews.
  • Identified performance issues, recommended and implemented solutions to resolve deficiencies.
  • Designed and implemented a backup and recovery strategy utilizing RMAN.
  • Performed extensive Stored Procedure performance optimization.
  • Managed seasonal and permanent resources.
  • Perform database recovery for any business critical issues, DR exercise and refresh of one database from another using RMAN.
  • Resolve database performance issues by identifying bottlenecks, connectivity and other database issues for SQL Server and Oracle databases.
  • Worked with technical team to tune, analyze and improve existing database and application server performance.
  • Designed logical and physical database backup strategies to meet MTTR requirements utilizing RMAN.
  • Worked on tuning and performance enhancements for a 7TB SAP production database.
  • Utilized OEM to start/stop database, backup/recovery, and performance monitoring.
  • Perform Query Performance tuning and resolve data issues and redundancies.
  • Re-designed the database (logical/physical) for better performance.
  • Worked on Performance tuning on the MYSQL/EC2 cloud environment.
  • Mentored Lockheed Martin employees on windows performance tuning techniques.
  • Led troubleshooting and performance tuning of the databases.
  • Moved database Schema changes to stage or production Database and SQL tuning to improve performance of loads.
  • Automated and scheduled NCCM databases backups using Oracle RMAN, Unix shell scripts and Cron job.
  • Worked with application developers to write highly performant custom SQL for applications.
  • Maintained backups & Recovery procedures using Netapp tools, RMAN etc.

Show More

1 Rman Jobs

No jobs at selected location

41. Data Migration

demand arrow
low Demand
Here's how Data Migration is used in Senior Database Architect jobs:
  • Implemented StatsPack and Quest Spotlight for performance monitoring Responsible for data migration from Test and Development environments.
  • Programmed SSIS ETLs for data migration and data warehouse update.

Show More

2 Data Migration Jobs

No jobs at selected location

42. Grid

demand arrow
low Demand
Here's how Grid is used in Senior Database Architect jobs:
  • Installed and configured Oracle Enterprise Manager 11g Grid Control on Linux for Production Server and Deploy Agents on Target Nodes.
  • Fix ASM/Grid related issues after a server instance is cloned from Amazon Machine Image (AMI).
  • Worked on setup of DataBuardBroker using GridCntrol to monitor DG performance.
  • Installed Oracle Enterprise Manager (OEM) Grid Control Console.
  • Developed GridCntrl jobs to run RMAN backups in place of cron.

Show More

43. CRM

demand arrow
low Demand
Here's how CRM is used in Senior Database Architect jobs:
  • Implement new e-branding campaign utilizing e-CRM technologies.
  • Designed/Developed the main sales tracking, Labor, CRM, BPR systems based on object-oriented/Star/ Relational designs.
  • Created series of Stored Procedures to convert data from legacy system to new CRM with validation testing.
  • Managed the data integration efforts in moving toward PeopleSoft Financials, HR, and CRM.

Show More

44. DTS

demand arrow
low Demand
Here's how DTS is used in Senior Database Architect jobs:
  • Created a data driven ETL development standard for PSP using Microsoft DTS.
  • Developed Excel templates and DTS packages for customer data imports.
  • Used SQL server 2000 DTS to automate the process.

Show More

45. Data Centers

demand arrow
low Demand
Here's how Data Centers is used in Senior Database Architect jobs:
  • Played a key role in successful migration of CheckfreePayLink payment processing system across data centers.
  • Implemented Always-On spanning two data centers and 3 replicas for HA/DR and RO purposes.
  • Designed the multi data centers data replication and synchronization using Oracle RAC, Data Guard and SAN storage.
  • Develop Disaster Recovery plans and procedures for offsite AZ and TX data centers.

Show More

46. AWS

demand arrow
low Demand
Here's how AWS is used in Senior Database Architect jobs:
  • Configure jobs to copy RMAN backups to AWS cloud S3 (Simple Storage Service).
  • Migrated Various Business Critical systems to AWS.

Show More

47. Ssas

demand arrow
low Demand
Here's how Ssas is used in Senior Database Architect jobs:
  • Cube uses SSAS Perspectives to make it easier for departments to see only the measures and dimensions they need.
  • Created SQL Server SSAS OLAP cubes including the definition of dimensions and measures.
  • Supported & maintained SSIS, SSRS, & SSAS deployments/packages.
  • Design and engineering of Claim based SSAS Cube sourced from a multi-terabyte OLTP system utilizing multi-partitioning with dynamic allocation.

Show More

48. Data Analysis

demand arrow
low Demand
Here's how Data Analysis is used in Senior Database Architect jobs:
  • Generated statistical data analysis & reports conducted a roadshow to stakeholders and collaborated with the businesses.
  • Assisted analyst with data analysis and data sourcing for report development.
  • Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.

Show More

1 Data Analysis Jobs

No jobs at selected location

49. QA

demand arrow
low Demand
Here's how QA is used in Senior Database Architect jobs:
  • Managed and administered databases in the development and QA environments.
  • Develop and write Agile CM and QA processes for data and databases using JIRA, SharePoint, and Tortoise SVN.
  • Worked with the QA department to control the build releases.
  • Worked on deploying SSIS packages on Dev to QA to UAT to Production by using Manifest file and run using DTExec.
  • Worked with Application/UAT teams for helping to move the production data over Test/Dev/QA environments using Datapump.

Show More

50. Javascript

demand arrow
low Demand

Senior Database Architect Jobs

NO RESULTS

Aw snap, no jobs found.

20 Most Common Skills For A Senior Database Architect

Pl/Sql

13.8%

Physical Database Design

10.2%

Database

10.1%

SQL

8.4%

Data Warehouse

6.8%

Database Architecture

5.8%

ETL

5.3%

DBA

5.0%

Physical Database Models

4.6%

Backup

4.0%

Ssis

3.3%

High Availability

3.0%

Oltp

2.7%

Recovery Procedures

2.7%

Capacity Planning

2.7%

Linux

2.5%

RAC

2.4%

DB

2.3%

Setup

2.2%

T-Sql

2.1%
Show More

Typical Skill-Sets Required For A Senior Database Architect

Rank Skill
1 Pl/Sql 9.7%
2 Physical Database Design 7.2%
3 Database 7.1%
4 SQL 5.9%
5 Data Warehouse 4.8%
6 Database Architecture 4.1%
7 ETL 3.7%
8 DBA 3.5%
9 Physical Database Models 3.3%
10 Backup 2.8%
11 Ssis 2.3%
12 High Availability 2.1%
13 Oltp 1.9%
14 Recovery Procedures 1.9%
15 Capacity Planning 1.9%
16 Linux 1.8%
17 RAC 1.7%
18 DB 1.6%
19 Setup 1.5%
20 T-Sql 1.5%
21 Unix 1.5%
22 Sybase 1.5%
23 C # 1.4%
24 Mysql 1.4%
25 XML 1.4%
26 Solaris 1.2%
27 Ssrs 1.2%
28 DB2 1.2%
29 Perl 1.2%
30 BI 1.1%
31 Internet 1.1%
32 SAN 1.1%
33 Rdbms 1.0%
34 Business Requirements 0.9%
35 Management System 0.9%
36 Olap 0.9%
37 Mongodb 0.9%
38 Production Environment 0.9%
39 Hadoop 0.8%
40 Rman 0.8%
41 Data Migration 0.8%
42 Grid 0.8%
43 CRM 0.8%
44 DTS 0.8%
45 Data Centers 0.8%
46 AWS 0.7%
47 Ssas 0.7%
48 Data Analysis 0.7%
49 QA 0.7%
50 Javascript 0.7%
{[{skill.rank}]} {[{skill.name}]} {[{skill.percentageDisplay}]}%
Show More

18,463 Senior Database Architect Jobs

Where do you want to work?

To get started, tell us where you'd like to work.
Sorry, we can't find that. Please try a different city or state.