Senior Oracle DBA - OMS/GIS
Sparktek
ROLE: Senior Oracle DBA - OMS/GIS
LOCATION: Onsite in NYC
RATE: 75-80/hr. C2C
RESPONSIBILITIES:
TECHNICAL SKILLS
Nice To Have
LOCATION: Onsite in NYC
RATE: 75-80/hr. C2C
RESPONSIBILITIES:
- Support eSRI and Schneider based GIS Environment & Databases
- GIS related Linux /Windows server requests built to client standards
- Performance monitoring and optimization of all ArcGIS / ArcFM Environments
- Maintaining sync jobs and reporting failures to the Application PoCs
- Support Build deployments
- Maintain configuration stores
- Provide ongoing database maintenance, including optimizing databases for specific applications.
- Update database software as required.
- SDE compress and rebuild index
- Maintaining growth, scalability, tasks and schedules
- Data synchronization and replication
- Maintenance of current editing workflows and version architecture
- Maintain enterprise geospatial data models for Gas and Electric ( Versioned and non versioned datasets)
- 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.
- Assist 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 .
TECHNICAL SKILLS
- 3+ years of experience with creating stored procedures in SQL
- advanced SQL development in Oracle SQL Developer
- Backend Database
- optimal oracle database design
Nice To Have
- ArcGIS
- ArcGIS Server, Portal
- Oracle Utilities
Vacancy posted 15 hours ago
Similar jobs that could be interesting for youBased on the Senior Oracle DBA - OMS/GIS in Hauppauge, NY vacancy
$27.98 - $29.25 per hour
A leading healthcare institution in Greenlawn, NY is seeking a Medical Assistant III to provide clinical support and manage patient care responsibilities. The ideal candidate will have a Medical Assistant certificate and at least 3 years of experience in a specialized area...SeniorGeographic information systemHourly pay- ...stonybrookmedicine.edu . Non-Tenure Track position. FLSA Exempt position, not eligible for the overtime provisions of the FLSA. To qualify for a senior faculty appointment, the candidate must meet the criteria established by the School of Medicine (School of Medicine's Criteria for...SeniorGeographic information systemWork at officeImmediate start
Stony Brook University
Stony Brook, NY3 days ago $100k - $160k
Annual Salary: $100k $160k (varies depending on years of experience) We are seeking an experienced NP or PA to join a high-volume Gastroenterology practice serving patients across the Long Island and Queens regions. The ideal candidate will bring prior GI experience...Geographic information systemPrivate practiceAtlas Search
Central Islip, NY2 days ago$350k
Outpatient Gastroenterology Practice in Smithtown, NY Catholic Health (CH) is seeking Board-Certified/Board Eligible Gastroenterologists to join our successful, highly regarded, and growing Gastroenterology practice in Smithtown, NY. The ideal candidate/s is...Geographic information systemImmediate startCatholic Health Service
Smithtown, NY2 days ago$350k
Catholic Health (CH) is seeking Board-Certified/Board Eligible Gastroenterologists to join our successful, highly regarded, and growing Gastroenterology practice in Smithtown, NY. The ideal candidate/s is trained in all aspects of Gastroenterology and have excellent interpersonal...Geographic information system- ...ROLE: GIS Developer LOCATION: Hybrid in NYC RATE: 90/hr. C2C JOB DESCRIPTION Provide development and technical... ...privileges. Coordinate with other teams like server support, security, DBA etc REQUIRED SKILLS/EXPERIENCE • 5-10 years of...Geographic information system
Sparktek
Hauppauge, NY3 days ago $58.91 - $64.91 per hour
St. Catherine Of Siena Hospital St. Catherine of Siena Hospital is a proud member of Catholic Health and has served the residents of the Smithtown area for more than 50 years. St. Catherine's is located on the north shore of Long Island in Smithtown. The campus is comprised...Geographic information systemWork at officeCatholic Health Service
Smithtown, NY4 days ago- divh2Job Title/h2pRegistered Nurse/ph3Job Description/h3pSt. Catherine of Siena Hospital is a proud member of Catholic Health and has served the residents of the Smithtown area for more than 50 years. St. Catherines is located on the north shore of Long Island in Smithtown...Geographic information systemWork at office
$124k - $280k
...Specialty/Competency: Oracle Industry/Sector: CM X-Sector Time Type: Full time Travel Requirements: Up to 80% A career... ...successful and progress in our careers, now and in the future. As a Senior Manager, you'll work as part of a team of problem solvers,...SeniorFull timeH1bPwC
Melville, NY2 days ago- Job Description If you're interested in the law and the legal profession, become an Army National Guard Paralegal, you will assist judges, Army lawyers, and unit commanders with legal matters and judicial work. The Paralegal Specialist provides legal and administrative...Geographic information systemContract workPart timeLocal areaWeekend work
National Guard OMD
Ronkonkoma, NY1 day ago - Job Description The UH-60 Black Hawk helicopter is the best-in-class, multi-mission performer used for combat assault, search and rescue, medevac, and firefighting missions. Your responsibility as the UH-60 Utility Helicopter Repairer will be to sustain the longevity...Geographic information systemPart timeWeekend work
National Guard OMD
Ronkonkoma, NY1 day ago $30 - $45 per hour
...Job Description Job Description Description: We are seeking a skilled Senior HVAC Technician to provide hands-on support for complex commercial and industrial HVAC systems. This is a multi-site, union role perfect for experienced technicians who enjoy troubleshooting...SeniorHourly payFull timeContract workImmediate startMonday to FridayCONTRACT PHARMACAL CORP
Hauppauge, NY28 days ago- Job Description The VA is seeking a dedicated Gastroenterologist to join our growing team. This role provides the opportunity to deliver high?quality digestive health care to Veterans while working within a collaborative, mission?driven environment. The ideal candidate...Geographic information systemTraineeship
Department of Veteran Affairs
Northport, NY29 days ago - Seeking Gastroenterology Faculty at Multiple UPMC Locations in the Pittsburgh Area The Division of Gastroenterology, Hepatology and Nutrition at the University of Pittsburgh School of Medicine and the University of Pittsburgh Medical Center (UPMC) invite applications for...Geographic information systemFull timeTraineeship
UPMC Southwestern PA
Brentwood, NY4 days ago - ...Job Description Job Description We are seeking a dynamic and experienced Senior Commercial Lines Account Manager, up to 110k, but negotiable. Must have experience remarketing accounts. The book is comprised of clients from these industries: Construction, Real Estate...Senior
Bing Recruitment
Islandia, NY23 days ago - WS Audiology USA in Hauppauge seeks a Marketing Leader to drive the end-to-end go-to-market strategy for the Signia brand across wholesale channels. Ideal candidates will have 6-8 years in B2B marketing, combined with experience in the healthcare sector, and a strong emphasis...Senior
$150k
Property/Casualty Producer job in Smithtown Smithtown, New York - NY AJC Search Associates, Ltd. Growing National Broker is looking for a proven Producer to join their team. Qualified candidate will currently be managing a significant book and will be looking for an opportunity...Senior$170k - $194k
Sisters of St. Joseph Brentwood is looking for a Senior Director of Health & Wellness to lead care for approximately 250 Sisters in various living environments. The role involves strategic wellness planning, team oversight, and implementation of innovative health practices...Senior$110.83k - $138.54k
A technology firm located in Hauppauge, NY, is seeking a Program Manager III to oversee project execution and team coordination. The successful candidate will manage project deliverables, report on milestones, and liaise with stakeholders. A strong technical background ...Senior- Heatherwood is looking for a Lead Technician to ensure exceptional service in a dynamic environment. This role involves hands-on maintenance, overseeing operational tasks, and leading a team of technicians. The ideal candidate will have at least 3 years of supervisory experience...Senior
$160k
H. T. PROF Group, based in Smithtown, NY, is seeking an experienced litigator to lead significant plaintiff and defense matters. The role requires a minimum of 5 years of active litigation experience and admission to the New York Bar. Candidates will engage directly with...Senior- .... C2C JOB DESCRIPTION We are seeking a highly skilled Senior Power BI Developer to join our dynamic team. In this role, you will... ...data visualization and integration for financial, utility, and GIS projects. Document development processes, data sources, and...Geographic information system
Sparktek
Hauppauge, NY2 days ago - A global leader in stored energy solutions is looking for a detail-oriented Senior Staff Accountant to assist with financial reporting and compliance. The ideal candidate will have a Bachelor’s degree in Accounting or Finance, along with over 5 years of experience in various...Senior
- A leading beauty retailer is seeking a Master Stylist in Commack, NY, responsible for delivering quality hair services and enhancing guest experiences. The ideal candidate will have a cosmetology license and strong communication skills, with a passion for the beauty industry...SeniorHourly pay
$37 - $45 per hour
St.-James-Rehabilitation-and-Healthcare-Center is seeking a highly motivated Respiratory Therapist to provide specialized care in a skilled nursing facility. Responsibilities include assessing and diagnosing respiratory conditions, developing treatment plans, and ensuring...SeniorHourly pay- Microchip Technology Inc. is seeking a Senior-II Validation Engineer in Hauppauge, NY. The role involves validating advanced connectivity devices, including Ethernet and USB products. Responsibilities include developing validation strategies, performing lab-based testing...Senior
- ...ROLE: Oracle PL/SQL Developer LOCATION: Hybrid in NYC RATE: 60/hr. W2 JOB DESCRIPTION... ...We are seeking a highly skilled Senior Enterprise Integration Developer with strong... ...enterprise applications, such as WMS, Oracle CIS, GIS, and Designer XI. Collaborate with...Geographic information systemWork at office
Sparktek
Hauppauge, NY15 hours ago $28 - $37 per hour
...required ~ Experience with Leica survey equipment desirable, but not required ~ Experience with Geographic Information Systems (GIS) desirable, but not required ~ Must have a valid driver's license ~ Must be able to lift and carry up to 75 lbs Our best estimate...Geographic information systemFull timeWork at officeFlexible hoursVanasse Hangen Brustlin , Inc.
Hauppauge, NY1 day ago- ...looking for an experienced personal injury manager to lead operational processes for managing cases in Brentwood, New York. In this senior-level role, you will be responsible for overseeing case production from intake to disbursement and ensuring high settlement rates...Senior
- Piping Rock in the Town of Islip, New York is seeking a Senior Brand Manager to lead the growth of their trusted health brands, Vitafusion and L’il Critters. This role combines brand strategy and operational execution, focusing on P&L management and product commercialization...Senior
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to Senior Oracle DBA - OMS/GIS. Be the first to apply!
Related searches
- senior performance engineer Hauppauge, NY
- senior manager diversity & inclusion Hauppauge, NY
- senior customer service Hauppauge, NY
- senior cybersecurity engineer Hauppauge, NY
- senior manager m&a tax Hauppauge, NY
- senior accountant remote Hauppauge, NY
- senior level Hauppauge, NY
- senior database analyst Hauppauge, NY
- senior international tax analyst Hauppauge, NY
- senior manager tax Hauppauge, NY