Current jobs related to Senior Oracle DBA - Irving - Kapital Data Corp


  • Irving, United States LTIMindtree Full time

    About LTIMindtreeLTIMindtree is a global technology consulting and digital solutions company that enables enterprises across industries to reimagine business models, accelerate innovation, and maximize growth by harnessing digital technologies. As a digital transformation partner to more than 750 clients, LTIMindtree brings extensive domain and technology...

  • Oracle / SQL Developer

    2 months ago


    Irving, United States The Dignify Solutions LLC Full time

    Job Duties/Responsibilities: Read & understand existing Oracle PL/SQL packages, stored procedures, and functions and apply enhancements based on new requirements and programming standards. Ability to develop UNIX/LINUX shell scripts and execute them based on requirements Develop, unit test, system test, schedule, and create deployment scripts for these...


  • Irving, Texas, United States Foot Locker Full time

    About the RoleThis is a challenging and rewarding opportunity to join Foot Locker's team as a Senior Software Engineer, Oracle ERP. As a key member of our cloud finance team, you will play a critical role in shaping the company's financial future by designing and implementing solutions that drive strategic goals.Key ResponsibilitiesDesign, develop,...


  • Irving, Texas, United States Foot Locker Full time

    About the RoleThis is a challenging and rewarding opportunity for a skilled Senior Software Engineer to join our team at Foot Locker. As a key member of our Oracle ERP Systems team, you will play a critical role in the development, implementation, and support of our Oracle Fusion Finance ERP application systems.Key ResponsibilitiesDesign and Develop ERP...


  • Irving, Texas, United States Motion Recruitment Partners LLC Full time

    Position Overview:We are looking for a Senior Oracle PL/SQL Engineer to join our dynamic team at Motion Recruitment Partners LLC. This role offers a unique opportunity to engage with cutting-edge technology and contribute to innovative solutions in a collaborative environment.Location: HybridContract Type: ContractCompensation: Competitive hourly rateKey...


  • Irving, Texas, United States Hire Talent Full time

    Position Overview:The role of the Oracle PL/SQL Developer involves a comprehensive understanding of Oracle database development, focusing on creating robust solutions that support enterprise-level applications. The ideal candidate will possess a minimum of 4 years of experience in Oracle PL/SQL development, demonstrating proficiency in various programming...


  • Irving, Texas, United States Mindlance Full time

    Position Overview:The role of the Oracle PL/SQL Developer involves leveraging over 4 years of expertise in Oracle PL/SQL programming across various software development areas. The candidate will be responsible for:Development and Maintenance: Crafting and sustaining intricate packages, stored procedures, functions, record structures, tables, views, indexes,...


  • Irving, Texas, United States Hire Talent Full time

    Position Overview:The Oracle PL/SQL Developer will play a crucial role in designing and implementing business logic within Oracle database packages, functions, and procedures. This position supports the development, deployment, and maintenance of large-scale enterprise web applications.Key Responsibilities:Develop and maintain intricate packages, stored...


  • Irving, Texas, United States Hire Talent Full time

    Position Overview:The role of the Oracle PL/SQL Developer is crucial in the implementation of business logic within Oracle database packages, functions, and procedures that support the development and maintenance of large-scale enterprise web applications.Key Responsibilities:Develop and maintain intricate packages, stored procedures, functions, record...


  • Irving, Texas, United States Mindlance Full time

    Position Overview:The role requires a seasoned Oracle PL/SQL Developer with over 4 years of experience in various software programming domains. The ideal candidate will be proficient in: Developing and managing intricate packages, stored procedures, functions, record structures, tables, views, indexes, triggers, and Oracle JSON. Conducting PL/SQL...


  • Irving, Texas, United States Mindlance Full time

    Position Overview:The Oracle PL/SQL Developer will play a critical role in the development and maintenance of complex database solutions. This position requires a strong background in Oracle PL/SQL programming, with a focus on creating and managing intricate packages, stored procedures, and functions.Key Responsibilities:Develop and maintain complex database...

  • Snowflake Developer

    2 months ago


    Irving, United States Midas Consulting Full time

    Detailed Job Description: Hands on experience in Snowflake or kinetica analytics databases 7+ years of experience on IQ, application DBA, performance tuning not just DBA, but also application tuning, ingestion framework. Data in Sybase IQ Experience in migrating other databases to Snowflake Programming skills - Class, library Automation tool for purging Good...


  • Irving, United States IDR Full time

    Job DescriptionJob DescriptionTo Apply for this Job Click Here IDR is seeking a SQL Database Administrator to join one of our clients ASAP in Irving, TX. If you are looking for an opportunity to join a global software integration company, please apply today! Please Note: This role does have an onsite requirement 5-days per week! Position Overview...


  • Irving, United States IDR Full time

    Job DescriptionJob DescriptionTo Apply for this Job Click Here IDR is seeking aSQL Database Administratorto join one of our clients ASAP in Irving, TX. If you are looking for an opportunity to join a global software integration company, please apply today!Please Note: This role does have an onsite requirement 5-days per week!Position Overview for the SQL...


  • Irving, United States IDR Full time

    Job DescriptionJob DescriptionTo Apply for this Job Click Here IDR is seeking a SQL Database Administrator to join one of our clients ASAP in Irving, TX. If you are looking for an opportunity to join a global software integration company, please apply today! Please Note: This role does have an onsite requirement 5-days per week! Position Overview...

  • Senior Java Full

    1 month ago


    Irving, Texas, United States Resource Informatics Group Full time

    Role: Senior Java full-stack DeveloperNeed Banking domain experience (Capital Markets or Investment banking experience or Fixed income)At least 10+ years of strong experience with enterprise-wide systems/platform - web development, Angular, React, nodeJS, JS frameworks.Hands-on experience with automated test frameworks - Jasmine, Karma, Protactor...


  • Irving, United States Epsilon Full time

    Job Description How You’ll Make an Impact Epsilon is seeking a Senior Database Developer to join our strong and steady Development team. You will implement, maintain and support proprietary database systems as part of our technical delivery team. Your primary responsibilities will focus on the development, implementation and testing of data...


  • Irving, United States NorthPoint Search Group Inc Full time

    Senior Financial Analyst Our client has an immediate need for a Senior Financial Analyst. This is a high profile role interacting with all levels of Finance. Duties: • Support Business Unit with budgets, forecast, business cases, and analysis for programs strategic decisions. • Liaison with the core finance & accounting group to drive profitability and...


  • Irving, Texas, United States Highgate Hotels Corporate Office TX Full time

    Compensation Type:Yearly Highgate Hotels: Highgate is a leading real estate investment and hospitality management firm recognized for its innovative approach within the sector. Highgate is a key player in U.S. gateway markets such as New York, Boston, Miami, San Francisco, and Honolulu, and is rapidly expanding its footprint in Europe, Latin America, and the...


  • Irving, United States Epsilon Full time

    Job Description Important: This is a hybrid-role working at least 2 days per week in the Irving, TX office. How You’ll Make an Impact Epsilon is seeking a Senior Database Developer to join our strong and steady Development team. You will implement, maintain, and support proprietary database systems as part of our technical delivery team. Your...

Senior Oracle DBA

1 month ago


Irving, United States Kapital Data Corp Full time
LOCATION
4 Irving Place
New York New York 10003

Must Have:
  • 3+ years of experience with creating stored procedures in SQL
  • dvanced SQL development in Oracle SQL Developer
  • Backend Database
  • optimal oracle database design
  • Senior Database Administrator
Nice To Have:
  • rcGIS
  • rcGIS Server, Portal
  • Oracle Utilities
OB DESCRIPTION

Support eSRI and Schneider based GIS Environment & Databases

o GIS related Linux /Windows server requests built to ConEd standards

o Performance monitoring and optimization of all ArcGIS / ArcFM Environments

o Maintaining sync jobs and reporting failures to the Application PoCs

o Support Build deployments

o Maintain configuration stores

o Provide ongoing database maintenance, including optimizing databases for specific applications.

o Update database software as required.

o SDE compress and rebuild index

o Maintaining growth, scalability, tasks and schedules

o Data synchronization and replication

o Maintenance of current editing workflows and version architecture

o Maintain ConEdison enterprise geospatial data models for Gas and Electric ( Versioned and non versioned datasets)

o Maintain the Esri ArcGIS Enterprise (10.6.1) and planned migrations
  • Experienced managing Geographic Information Systems (ArcGis, MapInfo, Oracle Spatial), SAP, Oracle Applications, Oracle Fusion Middleware, MySQL, DB2 and SQL Server.
  • Installation, configuration, upgrade and management of GIS (ESRI's AcrSDE, ArcFM, ArcIMS applications on Windows and Unix servers.
  • Created and managed ArcGIS user accounts, instances, services and permissions.
  • Designed and Managed SDE-Oracle database storage according to vendors recommended best practices. Configured dbtune file for Arcsde.
  • Designed and deployed disaster recovery plan for SDE servers, and Oracle databases using combinations of RMAN, export/import, Data Pump, Online, and cold backups.
  • Implemented Oracle Transparent Application Failure (TAF) with failover and load balancing capabilities for SDE-Database.
  • Scripted and scheduled shell scripts and batch scripts for monitoring SDE on SQL Server and Oracle database
  • Keep up with latest SDE releases by performing server upgrades, installing patches and service packs when necessary.
  • Set up SDE multi-user editing database, perform database compress, and re-orgs after editing. Scripted an upload process that refreshes the test SDE, and Oracle database environments to the production environment after versioning.
  • Installed, updated, and managed FlexLM single user and multi-user license files.
  • Update spatial metadata view with Dimensional Information about Geometrics
  • Created Spatial indexes, Parallel Spatial Indexes, Partitioned Spatial Indexes.
  • Provide support for version activities, and perform database reorgs to improve database performance.
  • Installation and configuration of Oracle Application server, OC4J and mapview for Oracle Spatial.
  • Undertook troubleshooting, research and resolution of complex database and application problems by closely monitoring and tuning database performance issues for SQL Server and Oracle databases on Unix and Windows operating systems.
  • Performed of SDE database/repository for SQL Server and Oracle.
  • Monitored OS file system, I/O, CPU, SWAP, memory and network utilizations on UNIX and Windows 2000 and ensures efficient use of disk storage, reclaim dead space, optimize space allocation and avoid out-of-space conditions.
  • Implemented, and maintained Oracle partitioning to distribute file system I/O, data archiving and database performance.
  • Perform server consolidation of over 5T from Solaris 10 to Linux.
  • Wrote PL/SQL programs to automate database maintenance activities.
  • Reviewed the physical model created from the logical model, ensuring the detailed physical design and data structures and databases complies with standards, guidelines, and procedure recommended for all aspects of data modeling, database design, and maintenance.
  • ssist developers in performing functional, unit and integration testing of applications.
  • Configure, deploy and management of backup and recovery strategies using RMAN, shell scripts, and Tivoli on
  • Database security Management, session management, set up database system, session and statement auditing strategies, creating and administering database users, roles, privileges and profiles to ensure compliance with corporate security and control standards, and SOX Act.
  • Performs database re-orgs and index rebuilds to reclaim spaces and optimize database performance.
  • Performed documentation, tracking, analysis, development, and validation of functional requirements and database design in a client/Server environment.
  • Refreshed Oracle databases and applications from one environment to another.
  • Performed information gathering and documenting business rules, change management and integration related issues.
  • Loading spatial (Points, Lines and Polygons) and non spatial data using inserts, SQL Loader, import & Export, Data Pump, and Transportable Tablespace.
  • Performed OS file system utilization monitoring, swap usage, CPU utilization, file I/O, and network tracing for Oracle.
  • Developed, tested and deployed PLSQL programs for database automation activities.
  • Cloning/Refreshing Of SDE database from one environment to another.
  • Database security Management, Session management. Performed object level, session, logon and system wide database audits of users to ensure user compliance with corporate security and controls standard, and SOX Act.
  • Creating and administering database users, roles, privileges and profiles.
  • Creation and configuration of Hot Standby Database and Data Guard across multiple servers.
  • Configuration of Oracle Names Server, and SQLNET for client connections to the database server.
  • Developed, deployed and maintained database backup/recovery environment (Cold and Hot) using RMAN, scripts and third party tools. Respond quickly to refresh data; verify of correct backup strategy; develop recovery procedures; support recovery from loss of data caused by user or system error. Perform application refreshes on request: Refresh data from one environment to another at the request of the application development staff; provide application development staff optimal development environment with current data.
  • Provided database support to application developers, application support and production users.
  • Performed Capacity planning and designs requirements for new databases on new/existing systems.
  • Designed and managed database security and audit procedures
  • Performed documentation, tracking, analysis, development, and validation of functional requirements and systems design.
  • Created and managed stored procedures, functions, packages, triggers, views, tables, indexes, table partitions, partitioned indexes; synonyms and db_links.
  • Monitored OS file system, I/O, CPU, Swap, memory and network utilizations.
  • Manage a combination of small, medium-sized and large-scale projects in a fast-paced environment.
  • Database Administration in Microsoft SQL Server
  • Performance monitoring and tuning of OLTP/OLAP database server and databases in MS SQL Server .