| GIS Database Administrator || Manhattan, NY || NO H1B at Manhattan, New York, USA |
| Email: [email protected] |
|
http://bit.ly/4ey8w48 https://jobs.nvoids.com/job_details.jsp?id=1557149&uid= Hi, Hope you are doing well. This is Manpreet Singh from 1 Points LLC. We are a global recruitment company with specialization in hiring IT professionals. Please go through the below job description and let me know if you are interested in the same. Role : GIS Database Adminsitrator Location : Manhattan, NY (Onsite) Duration : 6+ month contract Job Description Requirements: 3+ years of experience creating stored procedures in SQL. Advanced SQL development in Oracle SQL Developer. Experienced managing Geographic Information Systems (ArcGis, MapInfo, Oracle Spatial) SAP Oracle Applications Oracle Fusion Middleware MySQL DB2 SQL Server Responsibilities: Support eSRI and Schneider based GIS Environment & Databases. Maintain the Esri ArcGIS Enterprise (10.6.1) and planned migrations. GIS related Linux /Windows server requests built to client standards. Performance monitoring and optimization of all ArcGIS / ArcFM Environments. Maintain 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 client enterprise geospatial data models for Gas and Electric (Versioned and non-versioned datasets). Installation, configuration, upgrade and management of GIS (ESRIs AcrSDE, ArcFM, ArcIMS applications on Windows and Unix servers. Create and manage ArcGIS user accounts, instances, services and permissions. Design and manage SDE-Oracle database storage according to vendors recommended best practices. Configure dbtune file for Arcsde. Design and deploy disaster recovery plan for SDE servers, and Oracle databases using combinations of RMAN, export/import, Data Pump, Online, and cold backups. Implement Oracle Transparent Application Failure (TAF) with failover and load balancing capabilities for SDE-Database. Script and schedule 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. Install, update, and manage FlexLM single user and multi-user license files. Update spatial metadata view with Dimensional Information about Geometrics. Create Spatial indexes, Parallel Spatial Indexes, Partitioned Spatial Indexes. Provide support for version activities and perform database reorgs to improve database performance. Install and configure Oracle Application server, OC4J and mapview for Oracle Spatial. Troubleshoot, 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. Perform SDE database/repository for SQL Server and Oracle. Monitor 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. Implement and maintain Oracle partitioning to distribute file system I/O, data archiving and database performance. Perform server consolidation of over 5T from Solaris 10 to Linux. Write PL/SQL programs to automate database maintenance activities. Review 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 manage backup and recovery strategies using RMAN, shell scripts, and Tivoli. 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. Perform database re-orgs and index rebuilds to reclaim spaces and optimize database performance. Perform documentation, tracking, analysis, development, and validation of functional requirements and database design in a client/Server environment. Refresh Oracle databases and applications from one environment to another. Perform 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. Perform OS file system utilization monitoring, swap usage, CPU utilization, file I/O, and network tracing for Oracle. Develop, test and deploy 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. Create and administer database users, roles, privileges and profiles. Create and configure Hot Standby Database and Data Guard across multiple servers. Configure Oracle Names Server, and SQLNET for client connections to the database server. Develop, deploy and maintain 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. Provide database support to application developers, application support and production users. Perform Capacity planning and designs requirements for new databases on new/existing systems. Design and manage database security and audit procedures Perform documentation, tracking, analysis, development, and validation of functional requirements and systems design. Create and manage stored procedures, functions, packages, triggers, views, tables, indexes, table partitions, partitioned indexes; synonyms and db links. Monitor 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. Thanks & Regards Manpreet Singh Technical Recruiter | 1Point System LLC www.1pointsys.com [email protected] https://www.linkedin.com/in/manpreet-singh-a475301a5/ 115 Stone Village Drive Suite C Fort Mill, SC 29708 An E-Verified company | An Equal Opportunity Employer -- Keywords: database information technology golang microsoft procedural language New York South Carolina GIS Database Administrator || Manhattan, NY || NO H1B [email protected] http://bit.ly/4ey8w48 https://jobs.nvoids.com/job_details.jsp?id=1557149&uid= |
| [email protected] View All |
| 08:41 PM 12-Jul-24 |