[{"_1":2,"_556":-5,"_557":-5},"loaderData",{"_3":4,"_426":427},"root",{"_5":6,"_13":14,"_399":400,"_412":413,"_423":-7,"_424":-5,"_425":-5},"honeypotInputProps",{"_7":8,"_9":10,"_11":12},"nameFieldName","name__confirm","validFromFieldName","from__confirm","encryptedValidFrom","fL6hb+Fe3ifOiRlbBy3jK3irikbh2LoUx0MtWHnY7qwwVTNzgtjyRXs=","board",{"_15":16,"_17":16,"_18":19,"_20":21,"_26":27,"_28":29,"_32":33,"_36":37,"_44":45,"_48":49,"_64":65,"_66":67,"_74":75,"_195":196,"_210":211,"_241":242,"_273":274,"_280":281,"_285":286,"_387":388,"_393":394},"name","Mediabistro","fullName","siteUrl","https://www.mediabistro.com","pages",{"_22":23,"_24":25},"home","/","jobs","/jobs","mainCss",":root{--background:white;--foreground:black;--card:oklch(100% 0 0);--card-foreground:oklch(25% .001 0);--popover:white;--popover-foreground:black;--primary:oklch(59% .23 31.14);--primary-foreground:oklch(100% 0 0);--secondary:oklch(98% .001 0);--secondary-foreground:oklch(25% .001 0);--muted:oklch(97% 0 0);--muted-foreground:oklch(55.6% 0 0);--accent:oklch(96% 0 0);--accent-foreground:oklch(25% .001 0);--destructive:oklch(65% .15 15);--border:oklch(90% .001 0);--input:oklch(90% .001 0);--ring:oklch(70% .15 25);--chart-1:oklch(70% .15 25);--chart-2:oklch(70% .12 140);--chart-3:oklch(75% .12 60);--chart-4:oklch(45% .15 260);--chart-5:oklch(20% .02 280);--sidebar:oklch(98% .001 0);--sidebar-foreground:oklch(25% .001 0);--sidebar-primary:oklch(70% .15 25);--sidebar-primary-foreground:oklch(100% 0 0);--sidebar-accent:oklch(98% .001 0);--sidebar-accent-foreground:oklch(25% .001 0);--sidebar-border:oklch(90% .001 0);--sidebar-ring:oklch(70% .15 25);--footer-background:oklch(14% .07 288.16);--footer-foreground:oklch(100% 0 0);--footer-border:oklch(70% .15 25)}.dark{--background:oklch(14% .07 288.16);--foreground:oklch(100% 0 0);--card:oklch(29% .05 287.37);--card-foreground:oklch(100% 0 0);--muted:oklch(34% .02 255);--muted-foreground:oklch(78% .01 255);--popover:oklch(29% .05 287.37);--popover-foreground:oklch(100% 0 0);--border:transparent}","sitemaps",[30,31],"https://www.mediabistro.com/sitemap.xml","https://www.mediabistro.com/jobs-sitemap.xml","analytics",{"_34":35},"gtmId","GTM-NVDRG7Q","favicon",{"_38":39,"_40":41,"_42":43},"faviconSvg","https://www.mediabistro.com/public/favicons/favicon.svg","appleTouch","https://www.mediabistro.com/public/favicons/apple-touch-icon.png","manifest","https://www.mediabistro.com/public/favicons/site.webmanifest","metaTags",{"_46":47},"ogImage","https://www.mediabistro.com/public/site-logos/mediabistro-dark-social-1200x468.png","social",{"_50":51,"_52":53,"_58":59,"_60":61,"_62":63},"facebook","https://www.facebook.com/mediabistro","twitter",{"_54":55,"_56":57},"handle","@mediabistro","url","https://twitter.com/mediabistro","linkedin","https://www.linkedin.com/company/mediabistro","youtube","https://www.youtube.com/channel/UCnoZvx8SmZOMA1XteQAVtMQ","instagram","https://www.instagram.com/mediabistro/","helpEmail","help@mediabistro.com","transactionalEmail",{"_68":69,"_70":71,"_72":73},"fromAddress","support@mediabistro.com","userPasswordResetTemplateId","d-0614cbe7ddf0404893e7c9f8208331d5","clientPasswordResetTemplateId","d-ff1301b464d1436685573e406e4c1674","header",{"_76":77,"_88":89},"logo",{"_78":79,"_80":81,"_82":83,"_84":85,"_86":87},"whiteLogo","https://www.mediabistro.com/public/site-logos/2025-mb-logo.svg","darkLogo","https://www.mediabistro.com/public/site-logos/2025-mb-logo-dark.svg","logoClasses","w-[210px] h-[50px] lg:mb-1","width",300,"height",64,"items",[90,143,168,186],{"_91":92,"_93":94,"_95":96},"type","mega-menu","text","Jobs","columns",[97,112,134],{"_88":98},[99,102,106,109],{"_91":100,"_93":101,"_56":25},"internal-link","Search Creative Jobs",{"_91":103,"_93":104,"_56":105},"link","Hot Jobs","/career-advice/get-hired/hot-jobs/",{"_91":100,"_93":107,"_56":108},"Remote Media Jobs","/jobs?keyword=media&remote=true",{"_91":100,"_93":110,"_56":111},"Create Job Alerts","/create-alert",{"_113":114,"_88":115},"title","Job Categories",[116,119,122,125,128,131],{"_91":100,"_93":117,"_56":118},"Creative & Design","/jobs?category=Creative+%26+Design",{"_91":100,"_93":120,"_56":121},"Marketing & Communications","/jobs?category=Marketing+%26+Communications",{"_91":100,"_93":123,"_56":124},"Operations & Strategy","/jobs?category=Operations+%26+Strategy",{"_91":100,"_93":126,"_56":127},"Production","/jobs?category=Production",{"_91":100,"_93":129,"_56":130},"Sales & Business Development","/jobs?category=Sales+%26+Business+Development",{"_91":100,"_93":132,"_56":133},"Writing & Editing","/jobs?category=Writing+%26+Editing",{"_113":135,"_88":136},"Quick Links",[137,139,142],{"_91":100,"_93":138,"_56":25},"Search All Jobs",{"_91":100,"_93":140,"_56":141},"Remote Jobs","/jobs?remote=true",{"_91":100,"_93":110,"_56":111},{"_91":144,"_93":145,"_88":146},"dropdown","Career Resources",[147,150,153,156,159,162,165],{"_91":103,"_93":148,"_56":149},"Career Advice & Articles","/career-advice/",{"_91":103,"_93":151,"_56":152},"Media Industry News","/media-news",{"_91":103,"_93":154,"_56":155},"Creative Tools","https://playbook.mediabistro.com/",{"_91":100,"_93":157,"_56":158},"Resume Writing Services","/resume-writing-services/",{"_91":103,"_93":160,"_56":161},"Interview Coaching","https://www.wizco.io/ava?utm_source=mediabistro&utm_medium=job_board&utm_campaign=ava_interview_coaching&utm_content=resources_nav",{"_91":100,"_93":163,"_56":164},"Job Market Insights","/trends",{"_91":103,"_93":166,"_56":167},"Member Profiles","/freelance-connect/browse/",{"_91":144,"_93":169,"_88":170},"Mediabistro Membership",[171,174,177,180,183],{"_91":103,"_93":172,"_56":173},"Membership Overview","/unlimited/",{"_91":103,"_93":175,"_56":176},"How to Pitch (Premium Tool)","/career-advice/go-freelance/how-to-pitch/",{"_91":103,"_93":178,"_56":179},"Editorial Calendars (Premium Access)","/mastheads/",{"_91":103,"_93":181,"_56":182},"Courses & Training Programs","/online-training-courses/",{"_91":103,"_93":184,"_56":185},"Membership FAQ","/unlimited/frequently-asked-questions/",{"_91":144,"_93":187,"_88":188},"Showcase",[189,192],{"_91":103,"_93":190,"_56":191},"Featured Creative Stories","/showcase",{"_91":103,"_93":193,"_56":194},"Submit your Story","/my-account/?account_tab=showcase","footer",{"_76":197,"_198":199,"_200":201,"_202":203,"_204":205,"_206":207,"_208":209},{"_78":79,"_80":81,"_82":83},"cta","","logoText","Find your next media job or showcase your creative talent","copyright","Copyright © 2026 Mediabistro","termsOfUse","/terms-of-use/","termsOfService","/terms-of-service","privacyPolicy","/privacy-policy/","styleGuide",{"_212":213,"_217":218},"images",[214,215,216],"/_static/mediabistro/mb-logo-268x268.webp","/_static/mediabistro/android-chrome-192x192.png","/_static/mediabistro/mediabistro-text-logo.webp","colors",[219,223,226,229,232,235,238],{"_15":220,"_221":222},"$primary-color","value","#339999",{"_15":224,"_221":225},"$primary-color-light","#1ab9b3",{"_15":227,"_221":228},"$dark-blue","#3c405d",{"_15":230,"_221":231},"$green","#2D7E7E",{"_15":233,"_221":234},"$grey","rgba(47, 47, 48, 0.93)",{"_15":236,"_221":237},"$darkgrey","rgba(44, 43, 45, 0.98)",{"_15":239,"_221":240},"$light-grey","#F3F3F4","jobsSearch",{"_243":244,"_251":252},"emptyMeta",[245,247],{"_113":246},"Media, Marketing & Creative Job Board | Journalism & Ad Jobs",{"_15":248,"_249":250},"description","content","The #1 job board for media, marketing, and communications professionals. Search career opportunities in advertising, public relations, journalism, and creative arts.","websiteSchema",[253],{"_254":255},"script:ld+json",{"_256":257,"_258":259,"_15":16,"_260":261,"_56":262,"_263":264},"@context","https://schema.org","@type","WebSite","alternateName","MB","https://mediabistro.com/jobs","potentialAction",{"_258":265,"_266":267,"_271":272},"SearchAction","target",{"_258":268,"_269":270},"EntryPoint","urlTemplate","https://mediabistro.com/jobs?keyword={keyword}","query-input","required name=keyword","hero",{"_113":275,"_276":277,"_198":278,"_93":279},"Find Your Next Media Job","subtitle","Discover creative opportunities at the world's leading media brands","Start Your Search","Search Media, Marketing & Creative Jobs","flags",{"_282":283,"_284":283},"extendedFilters",true,"weeklyNewsletter","postJobs",{"_287":288,"_273":293,"_296":297,"_298":299,"_280":303,"_307":308,"_320":321,"_326":327,"_331":332,"_347":348,"_350":351},"meta",[289,291],{"_113":290},"Post a Job | Hire Media, Marketing & Creative Talent - Mediabistro",{"_15":248,"_249":292},"Recruit qualified media and creative professionals on the #1 industry job board. Reach top talent in design, social media, advertising, and communications. Post a job today.",{"_113":294,"_276":295,"_248":199},"The #1 Job Board for Media, Marketing & Creative Talent","Skip the unqualified resumes. Reach journalism, publishing, and marketing pros who are ready to work.","unlimitedJobsEmail","clients@mediabistro.com","enterpriseCta",{"_93":300,"_301":302},"*Unlimited plan is for direct employers only. Hiring at scale, posting on behalf of clients, or distributing across job boards?","linkText","Contact us for custom volume pricing, multi-brand support, and programmatic distribution.",{"_304":283,"_305":283,"_306":283},"showMediaBoardSection","showRolesSection","showPlanIcon","mediaBoardSection",{"_113":309,"_276":310,"_248":311,"_312":313,"_318":319},"The #1 Destination for Media","and Creative Talent","Connect with top-tier full-time and freelance media professionals. Whether you are a leading publisher, a streaming service, or a growing brand, we deliver specialized talent you won't find on generalist job boards. Find your perfect match for:","bullets",[314,315,316,317],"News, Journalism & Book Publishing","Content Marketing, AI Prompt Engineering & Copywriting","Influencer Management, TV & Video Production","PR, Non-Profits & Education","imageAlt","Job seekers and featured job cards collage","rolesSection",{"_113":322,"_276":323,"_248":324,"_318":325},"Hire Remote and Local Talent","Across Every Media Vertical","Whether you are building an in-office team or seeking remote talent, access a specialized network of professionals in editorial, publishing, influencer marketing, and AI content strategy. Find candidates—from prompt engineers to production leads—who are ready to contribute from anywhere.","Media roles infographic","testimonialsSection",{"_113":328,"_276":329,"_248":330},"Trusted by Leading Media","and Creative Employers","See why top publishers, agencies, and brands rely on us to find exceptional talent.","testimonials",[333,339,343],{"_334":335,"_336":337,"_76":338},"company","Huffpost","quote","I love using Mediabistro for my harder to fill creative roles. Multimedia positions like photo editors, video producers, or even niche journalists yield great results. Other job boards don't always produce the specialized talent my hiring teams are looking for, and I feel like I can find that talent through Mediabistro.","https://production-rails-default.s3.us-east-2.amazonaws.com/public/post-jobs-logos/huff-post-400x200.png",{"_334":340,"_336":341,"_76":342},"NBCUniversal","Mediabistro is valuable partner when it comes to finding top candidates in the media industry. Their team is extremely responsive, which makes the posting process quick and easy. They also offer great insight into branding company pages.","https://production-rails-default.s3.us-east-2.amazonaws.com/public/post-jobs-logos/nbc-universal-400x200.png",{"_334":344,"_336":345,"_76":346},"The Taunton Press","What we like best about Mediabistro is the quality of targeted talent they deliver through their job board portal. We know we'll find the right type of talent for specialized positions that may be more challenging to fill. For almost fifteen years, Mediabistro has been our go-to resource for talent in the media/publishing space.","https://production-rails-default.s3.us-east-2.amazonaws.com/public/post-jobs-logos/taunton-press-400x200.png","employersSection",{"_113":349,"_276":16},"Media and Creative Employers on","employerLogos",[352,354,357,360,363,366,369,372,375,378,381,384],{"_15":340,"_353":342},"image",{"_15":355,"_353":356},"Bloomberg","https://production-rails-default.s3.us-east-2.amazonaws.com/public/post-jobs-logos/bloomberg-400x200.png",{"_15":358,"_353":359},"Meredith","https://production-rails-default.s3.us-east-2.amazonaws.com/public/post-jobs-logos/meredith-400x200.png",{"_15":361,"_353":362},"Dotdash","https://production-rails-default.s3.us-east-2.amazonaws.com/public/post-jobs-logos/dotdash-400x200.png",{"_15":364,"_353":365},"Penske Media Corporation","https://production-rails-default.s3.us-east-2.amazonaws.com/public/post-jobs-logos/penske-media-corporation-400x200.png",{"_15":367,"_353":368},"Springer Nature","https://production-rails-default.s3.us-east-2.amazonaws.com/public/post-jobs-logos/springer-nature-400x200.png",{"_15":370,"_353":371},"Penguin Random House","https://production-rails-default.s3.us-east-2.amazonaws.com/public/post-jobs-logos/penguin-random-house-400x200.png",{"_15":373,"_353":374},"Fox Corporation","https://production-rails-default.s3.us-east-2.amazonaws.com/public/post-jobs-logos/fox-corporation-400x200.png",{"_15":376,"_353":377},"Future","https://production-rails-default.s3.us-east-2.amazonaws.com/public/post-jobs-logos/future-400x200.png",{"_15":379,"_353":380},"Hearst Television","https://production-rails-default.s3.us-east-2.amazonaws.com/public/post-jobs-logos/hearst-television-400x200.png",{"_15":382,"_353":383},"Cox Enterprises","https://production-rails-default.s3.us-east-2.amazonaws.com/public/post-jobs-logos/cox-enterprises-400x200.png",{"_15":385,"_353":386},"Leaf Group","https://production-rails-default.s3.us-east-2.amazonaws.com/public/post-jobs-logos/leaf-group-400x200.png","createAlertMeta",[389,391],{"_113":390},"Create Job Alerts | Media, Marketing & Creative Job Alerts",{"_15":248,"_249":392},"Never miss an opportunity. Sign up for free email alerts and get the latest jobs in social media, graphic design, writing, and marketing delivered to your inbox.","jobsPortalSignupMeta",[395,397],{"_113":396},"Sign Up | Creative, Marketing & Media Job Search",{"_15":248,"_249":398},"Create your free profile to apply for jobs, upload your resume, and set job alerts. Join the leading career community for creative, marketing, and media professionals.","requestInfo",{"_401":402,"_407":19,"_408":409,"_410":411},"hints",{"_403":404,"_405":406},"theme","light","timeZone","UTC","origin","path","/jobs/2795850654-ansible-automation-platform-sr-consultant-remote-role","userPrefs",{"_403":404},"env",{"_414":415,"_416":417,"_418":419,"_420":421,"_422":19},"MODE","production","SENTRY_ENV","mediabistro","NEW_JOB_BOARD_SENTRY_DSN","https://235251e3654b447a82e934b7c2ce7c93@o4504103609303040.ingest.sentry.io/4504806528253952","SENTRY_RELEASE","7835064746aa2506a6915b7f131768b016acbdfb","WEBSITE_URL","user","toast","confettiId","routes/_public.jobs.$id",{"_428":429,"_429":430,"_497":498,"_516":434,"_517":434,"_518":519},"kind","job",{"_431":432,"_433":434,"_435":434,"_436":129,"_437":199,"_438":199,"_439":440,"_441":-7,"_113":442,"_248":443,"_444":445,"_446":447,"_448":199,"_449":450,"_460":461,"_462":199,"_463":199,"_464":199,"_56":465,"_466":199,"_467":199,"_468":469,"_470":469,"_471":472,"_473":434,"_474":475,"_476":409,"_477":478,"_479":480,"_481":482,"_486":487,"_488":442,"_489":453,"_490":199,"_491":492,"_493":494,"_495":496},"id",["B","2795850654"],"promoted",false,"remoteAllowed","category","duration","experienceLevel","publishedAt",["D",1772780400000],"indexedAt","Ansible Automation Platform Sr. Consultant remote role","Ansible Automation Platform Sr. Consultant

Technical Skills:\nJob Requirements:\nRed Hat IPU Continue to triage / fix IPU issues\nMQ Client Automation to remove all old MQ clients and install the MQ 9.3 client\nDetermine the release strategy for MQ clients to determine if a regular cadence of updates is required\nOracle 11g / Oracle 12c Client rem...\n","descriptionText","Ansible Automation Platform Sr. Consultant remote role RIT Solutions Sales & Business Development Ansible Automation Platform Sr. Consultant Technical Skills: Job Requirements: Red Hat IPU Continue to triage / fix IPU issues MQ Client Automation to remove all old MQ clients and install the MQ 9.3 client Determine the release strategy for MQ clients to determine if a regular cadence of updates is required Oracle 11g / Oracle 12c Client rem...","shortDescription","Ansible Automation Platform Sr. Consultant

Technical Skills:\nJob Requirements:\nRed Hat IPU Continue to triage / fix IPU issues\nMQ Client A...","location","locations",[451],{"_452":453,"_454":455,"_456":457,"_458":459},"formatted","New York, NY, United States","city","New York","state","NY","country","United States","companyName","RIT Solutions","salaryMin","salaryMax","salaryDescription","https://us.thebigjobsite.com/redirectfeedjob?jobid=2B5DE6C109ABE74F611246D6612E8441&source=mediabistroxmlus&utm_source=mediabistroxmlus&jobSiteKey=D385BAAA18027602F285603787B58A59","companyDescription","companyWebsite","displayLogo","https://www.mediabistro.com/public/images/desk-100x50.webp","displayThumbnail","displayHeadline","Work at RIT Solutions","isManualPosted","costPerClick",0.15,"displayUrl","fullUrl","https://www.mediabistro.com/jobs/2795850654-ansible-automation-platform-sr-consultant-remote-role","strippedDescription","Ansible Automation Platform Sr. ConsultantTechnical Skills:\nJob Requirements:\nRed Hat IPU Continue to triage / fix IPU issues\nMQ Client Automation to remove all old MQ clients and install the MQ 9.3 client\nDetermine the release strategy for MQ clients to determine if a regular cadence of updates is required\nOracle 11g / Oracle 12c Client rem...\n","parsedLocation",{"_452":453,"_483":199,"_484":199,"_454":455,"_456":457,"_458":459,"_485":199},"street1","street2","postal_code","displayPublishedAt","16 days ago","shortTitle","shortLocation","level","searchCompanyPath","/jobs?keyword=RIT+Solutions","searchLocationPath","/jobs?location=New+York%2C+NY%2C+United+States","searchTitlePath","/jobs?keyword=Ansible+Automation+Platform+Sr.+Consultant+remote+role","featuredCompany",{"_431":499,"_15":500,"_501":434,"_76":502,"_503":504,"_248":505,"_448":506,"_507":-5,"_508":-5,"_509":-5,"_510":-5,"_511":512,"_513":514,"_468":502,"_476":515,"_470":502},211,"Mansueto Ventures","agency","https://production-rails-default.s3.us-east-2.amazonaws.com/public/legacy-logos/109473.JPG","slug","mansueto-ventures-careers","

Mansueto Ventures is home to two of the most iconic and vibrant brands in business publishing: Inc. and Fast Company. Every day, the content, awards, and events produced help entrepreneurs and innovators succeed by providing useful insights, sparking essential conversations, and offering much-needed inspiration.

Inc. is the voice of the American entrepreneur, inspiring and documenting the risk-takers and ultra-driven go-getters who represent the most dynamic force in the American economy.
Fast Company is the world’s leading business media brand, focusing on innovation in technology, leadership, and design to inspire readers to shape the future of business.

","New York, NY","coloredLogo","logoAttachment","thumbnail","thumbnailAttachment","hexCode","#080D0C","headline","Publisher of Inc. and Fast Company, empowering innovators and entrepreneurs.","/companies/mansueto-ventures-careers","hasJobSubmission","isSavedJob","similarJobs",[520,540],{"_435":434,"_439":521,"_468":469,"_460":522,"_248":523,"_446":524,"_433":434,"_113":525,"_437":199,"_438":199,"_470":469,"_448":199,"_449":526,"_431":532,"_471":533,"_436":120,"_486":534,"_476":535,"_488":525,"_489":536,"_491":537,"_493":538,"_495":539},["D",1774159200000],"Avani Technology Solutions","Role:

Oracle DBA

Location -

Chicago, IL

Duration -

6+ Months

Top Three Skills

1. Oracle 11g / 12c

2. RAC/ASM

3. Oracle DataGuard

Duties and Key Responsibilities:\n• Manage individual workload and deliver to agreed-upon milestones, require minimal supervision to perform job duties.\n• Plan, design, and build high performance database systems.\n• Work with architect, application and infrastructure teams on implementing customer-servicing application releases and infrastructure projects.\n• Analyze database & system response time and determine tuning recommendations to improve performance.\n• Effectively manage issue identification and resolution process.\n• Participate in, and encourage a knowledge-sharing environment both within, and outside the department.\n• Participate in on-call duties.

Experience and Educational Requirements:\n• Bachelors degree in related technical / business area is required. Computer Science, Information Services, mathematics, engineering or related field.\n• Strong problem solving skills with the ability to quickly and efficiently pinpoint and resolve problematic system issues.\n• 5-10 years experience of UNIX (IBM AIX or Linux) platform, Oracle RAC/ASM, RMAN, OEM, Oracle Partitioning, Shell scripting and/or PL/SQL scripting, Oracle Dataguard and Oracle Net are required\n• Must have strong GoldenGate skills\n• 3-5 years experience of Exadata, Oracle OVD, Oracle GoldenGate, Microsoft SQL Server and/or Hadoop is highly desirable.\n• Strong change management skills; change agent.\n• Excellent written and verbal communication skills.\n• Experience supporting mission critical infrastructure in a fast paced environment.\n","Role:

Oracle DBA

Location -

Chicago, IL

Duration -

6+ Months

Top Three Skills

1. Ora...","Oracle DBA",[527],{"_458":459,"_454":528,"_452":529,"_456":530,"_485":531},"Chicago","Chicago, IL, United States, 60290","IL","60290",["B","2968217217"],"Work at Avani Technology Solutions","8 hours ago","/jobs/2968217217-oracle-dba","Chicago, IL, United States","/jobs?keyword=Avani+Technology+Solutions","/jobs?location=Chicago%2C+IL%2C+United+States","/jobs?keyword=Oracle+DBA",{"_435":434,"_439":541,"_468":469,"_460":542,"_248":543,"_446":544,"_433":434,"_113":545,"_437":199,"_438":199,"_470":469,"_448":199,"_449":546,"_431":550,"_471":551,"_436":120,"_486":552,"_476":553,"_488":545,"_489":453,"_491":554,"_493":494,"_495":555},["D",1773079200000],"RIT Solutions, Inc.","Support Oracle OMS and eSRI based GIS Environment & Databases\no OMS and GIS related Linux /Windows server requests built to Client standards\no Performance monitoring and optimization of all ArcGIS / ArcFM Environments\no Maintaining sync jobs and reporting failures to the Application PoCs\no Support Build deployments\no Maintain configuration stores\no Provide ongoing database maintenance, including optimizing databases for specific applications.\no Update database software as required.\no SDE compress and rebuild index\no Maintaining growth, scalability, tasks and schedules\no Data synchronization and replication\no Maintenance of current editing workflows and version architecture\no Maintain Client enterprise geospatial data models for Gas and Electric ( Versioned and non versioned datasets)\no Maintain the Esri ArcGIS Enterprise (10.6.1) and planned migrations\n• Experienced managing Geographic Information Systems (ArcGis, MapInfo, Oracle Spatial), SAP, Oracle Applications, Oracle Fusion Middleware, MySQL, DB2 and SQL Server.\n• Installation, configuration, upgrade and management of GIS (ESRI's AcrSDE, ArcFM, ArcIMS applications on Windows and Unix servers.\n• Created and managed ArcGIS user accounts, instances, services and permissions.\n• Designed and Managed SDE-Oracle database storage according to vendors recommended best practices. Configured dbtune file for Arcsde.\n• Designed and deployed disaster recovery plan for SDE servers, and Oracle databases using combinations of RMAN, export/import, Data Pump, Online, and cold backups.\n• Implemented Oracle Transparent Application Failure (TAF) with failover and load balancing capabilities for SDE-Database.\n• Scripted and scheduled shell scripts and batch scripts for monitoring SDE on SQL Server and Oracle database\n• Keep up with latest SDE releases by performing server upgrades, installing patches and service packs when necessary.\n• 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.\n• Installed, updated, and managed FlexLM single user and multi-user license files.\n• Update spatial metadata view with Dimensional Information about Geometrics\n• Created Spatial indexes, Parallel Spatial Indexes, Partitioned Spatial Indexes.\n• Provide support for version activities, and perform database reorgs to improve database performance.\n• Installation and configuration of Oracle Application server, OC4J and mapview for Oracle Spatial.\n• 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.\n• Performed of SDE database/repository for SQL Server and Oracle.\n• 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.\n• Implemented, and maintained Oracle partitioning to distribute file system I/O, data archiving and database performance.\n• Perform server consolidation of over 5T from Solaris 10 to Linux.\n• Wrote PL/SQL programs to automate database maintenance activities.\n• 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.\n• Assist developers in performing functional, unit and integration testing of applications.\n• Configure, deploy and management of backup and recovery strategies using RMAN, shell scripts, and Tivoli on\n• 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.\n• Performs database re-orgs and index rebuilds to reclaim spaces and optimize database performance.\n• Performed documentation, tracking, analysis, development, and validation of functional requirements and database design in a client/Server environment.\n• Refreshed Oracle databases and applications from one environment to another.\n• Performed information gathering and documenting business rules, change management and integration related issues.\n• Loading spatial (Points, Lines and Polygons) and non spatial data using inserts, SQL Loader, import & Export, Data Pump, and Transportable Tablespace.\n• Performed OS file system utilization monitoring, swap usage, CPU utilization, file I/O, and network tracing for Oracle.\n• Developed, tested and deployed PLSQL programs for database automation activities.\n• Cloning/Refreshing Of SDE database from one environment to another.\n• 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.\n• Creating and administering database users, roles, privileges and profiles.\n• Creation and configuration of Hot Standby Database and Data Guard across multiple servers.\n• Configuration of Oracle Names Server, and SQLNET for client connections to the database server.\n• 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.\n• Provided database support to application developers, application support and production users.\n• Performed Capacity planning and designs requirements for new databases on new/existing systems.\n• Designed and managed database security and audit procedures\n• Performed documentation, tracking, analysis, development, and validation of functional requirements and systems design.\n• Created and managed stored procedures, functions, packages, triggers, views, tables, indexes, table partitions, partitioned indexes; synonyms and db_links.\n• Monitored OS file system, I/O, CPU, Swap, memory and network utilizations.\n• Manage a combination of small, medium-sized and large-scale projects in a fast-paced environment.\n• Database Administration in Microsoft SQL Server\n• Performance monitoring and tuning of OLTP/OLAP database server and databases in MS SQL Server.

TECHNICAL SKILLS Must Have\n• 3+ years of experience with creating stored procedures in SQL\n• advanced SQL development in Oracle SQL Developer\n• a seasoned Oracle Database Administrator\n• Backend Database\n• optimal oracle database design\n• Senior Database Administrator

Nice To Have\n• administration and testing of Enterprise GIS and Database Projects\n• ArcGIS\n• ArcGIS Server, Portal\n• Oracle Utilities\n","Support Oracle OMS and eSRI based GIS Environment & Databases\no OMS and GIS related Linux /Windows server requests built to Client standards\no Perf...","Sr. Oracle DBA - OMS/GIS",[547],{"_458":459,"_454":455,"_452":548,"_456":457,"_485":549},"New York, NY, United States, 10261","10261",["B","2833049373"],"Work at RIT Solutions, Inc.","12 days ago","/jobs/2833049373-sr-oracle-dba-oms-gis","/jobs?keyword=RIT+Solutions%2C+Inc.","/jobs?keyword=Sr.+Oracle+DBA+-+OMS%2FGIS","actionData","errors"]