Job Summary:

• Responsible for SQL Server security and managing both front-end and back-end access to all databases, including security configuration for Microsoft SSRS.
• Responsible for SQL Server and database architecture and design to ensure availability and performance needs are realized by end users.
• Design, develop, install, and support all Nassau Financial Microsoft SQL databases to support Business Unit and Application Development.
• Responsible for identifying and implementing improvements to SQL databases to optimize performance.
• Supports and maintains database and data management processes within the Credit Union environment. 
• Works with others in IT to design, deploy, and manage SQL-based systems (including by not limited to. ARCU, Synapsys, Passageways, and eDoc Logic)
• Develops, revises, implements, and consistently maintains policies and guidelines necessary to effectively administer the Credit Union’s database and application environments.
• Administer, test, and implement computer databases
• Install and configure new SQL Server Database Instance to specified guidelines or 3rd party application requirements
• Ability to configure security within established guidelines
• Implement security measures to safeguard computer databases
• Monitor performance space on servers and databases
• Respond to database problems and escalations
• Provide trend analysis and reporting

Skills on Resume: 

• SQL Server Security Management (Hard Skills)
• Database Architecture and Design (Hard Skills)
• Performance Optimization (Hard Skills)
• Database Administration (Hard Skills)
• Policy Development and Maintenance (Hard Skills)
• System Deployment and Management (Hard Skills)
• Security Implementation (Hard Skills)
• Problem-Solving and Escalation Management (Soft Skills)

Job Summary:

• Perform database structure analysis, software maintenance, and implementation and provide administrative support for DB2 databases and related applications
• Understand Data Flows and troubleshoot data-related incidents via ETL Tools, Apache Spark, Airflow
• Strong Understanding of Performance Tuning and Data monitoring using Cloud-based monitoring tools
• Maintain and adjust support response schedules for timely acknowledgment and resolution of complete service offerings
• Troubleshoot issues and provide support to the application teams (on-call) to resolve critical issues affecting the application availability.
• Ensure that new database code meets company standards for readability, reliability, and performance.
• Report on server utilization and provide suggestions on how to improve performance.
• Proactively develop and improve the performance of various queries by tweaking or modifying indexes.
• Host knowledge-sharing sessions with colleagues to enhance the team's SQL capabilities.
• Determine appropriate techniques including deciding whether clustering, log shipping, mirroring, and always-on availability group replication are the right fit for business continuity.
• Assess and develop long-term strategic goals for production databases and other database environments including refresh schedules.\
• Led projects of deployments of new DLx environments, application servers as well as databases, whilst providing technical leadership and ownership of issues relating to DLx
• Maintain the DLx environments on a day-to-day basis, including Patching and Linux system administration of the DLx application servers and downstream database refreshes.
• Conduct performance tuning and troubleshooting, SQL performance tuning, Configure, test, debug, and document environments, as appropriate
• Research and implement appropriate best practices and tools and assist the MWS developers with database-related issues. 

Skills on Resume: 

• Database Structure Analysis and Maintenance (Hard Skills)
• Data Flow Understanding and Troubleshooting (Hard Skills)
• Performance Tuning and Monitoring (Hard Skills)
• Support Response Management (Soft Skills)
• Application Support and Troubleshooting (Hard Skills)
• Code Quality Assurance (Hard Skills)
• Server Utilization Reporting and Performance Improvement Suggestions (Hard Skills)
• SQL Optimization and Knowledge Sharing (Hard Skills)

Job Summary:

• Led projects of deployments of new DLx environments, both the application servers as well as the databases.
• Provide technical leadership and ownership of issues relating to DLx.
• Patching of existing DLx environments.
• Linux system administration of the DLx application servers.
• Provide oversight and facilitation of the IT change management process.
• Conduct performance tuning and troubleshooting.
• Maintain the DLx environments on a day-to-day basis.
• Do downstream database refreshes and SQL performance tuning.
• Assist the MWS developers with database-related issues.
• Research and implement appropriate best practices, and tools.
• Assist the MWS team with L3 support.
• Be in good contact with Blue Yonder, for support and Licensing
• Research and recommend solutions to improve business performance and/or reduce cost.
• Configure, test, debug, and document environments, as appropriate.

Skills on Resume: 

• Project Management (Hard Skills)
• Technical Leadership (Soft Skills)
• System Administration (Hard Skills)
• Change Management (Soft Skills)
• Performance Tuning and Troubleshooting (Hard Skills)
• Database Management (Hard Skills)
• Research and Implementation (Hard Skills)
• Vendor Management (Soft Skills)

Job Summary:

• Implement, architect, and set best practices for Oracle Applications and databases
• Implement monitoring scripts and set best practices for the Oracle E-Business suite including Oracle components, concurrent requests, system alerts, and metrics.
• Implement monitoring scripts and set best practices for Oracle Middleware and Related Applications
• Implement monitoring scripts of Oracle databases for performance problems and recommend performance-tuning actions using Oracle utilities; other vendor software and utilities, or programs developed independently.
• Recommend, test, and implement new releases of Oracle applications and middleware components.
• Respond to and resolve Oracle access and performance issues
• Design and implement new databases as required by Company business requirements and assist in the development of utilities/programs to be used in the loading of data into the databases.
• Review and maintain policies and procedures pertaining to application and database recovery and disaster recovery.
• Participate in the installation and maintenance of Oracle technology stack products and utilities.
• Develop, implement, and maintain change control and testing procedures for modifications to Oracle databases.
• Research and recommend Oracle application support products and tools and application development products and tools.
• Recommend, establish, and implement Oracle database policies and procedures to ensure the integrity, recoverability, and availability of the Company’s data controlled by these databases.
• Perform off-hours production support and mentor junior members of the group
• Plan and coordinate data migrations between operating systems.
• Work with application development staff to establish Oracle coding and testing policies and standards as well as assist/answer any questions/problems regarding application development.

Skills on Resume: 

• Oracle Applications and Databases Implementation (Hard Skills)
• Monitoring and Best Practices (Hard Skills)
• Performance Tuning (Hard Skills)
• Release Management (Hard Skills)
• Issue Resolution (Hard Skills)
• Database Design and Development (Hard Skills)
• Disaster Recovery Planning (Hard Skills)
• Change Control and Testing (Hard Skills)

Job Summary:

• Support database development and support for back-office software engineering teams.
• Work collaboratively with the engineering project teams to consult on application design, optimize database utilization, and performance tuning, recommend efficient data schemas, and database application development.
• Real-time payment and supplier management processing, complex and multi-national financial accounting reporting and transaction automation, high-volume trade processing and prime broker reconciliations, trade affirmation venue integration, profit and loss statements, investor and fund accounting, and employee/payroll reporting and processing cycles.
• Developing and administering database enhancements and systems. 
• Responsible for delivering capacity and performance management programs to ensure system reliability. 
• Assisting and developing developer database programming to ensure quality database procedures and configuration. 
• Coordinating deployments, database planned maintenance, and development with core database administration team.
• Monitoring and enhancing applications so that database queries and transactions perform within optimal levels and efficiency.
• Understand and translate business requirements into technical design specifications
• Implement application database capacity and performance management processes.
• Review database architectures, schemas, and security processes to ensure technical designs
• Develop technical and software solutions using test-driven and agile software development methodologies
• Participate in identifying new database technologies and methodologies to continuously improve database speed and efficiency.
• Implement application database monitoring and create proactive performance monitoring and tuning recommendations.

Skills on Resume: 

• Database Development and Support (Hard Skills)
• Collaboration with Engineering Teams (Soft Skills)
• Financial and Accounting Domain Knowledge (Hard Skills)
• Database Administration (Hard Skills)
• Database Programming (Hard Skills)
• Deployment Coordination (Soft Skills)
• Performance Monitoring and Enhancement (Hard Skills)
• Business Requirement Translation (Soft Skills)

Job Summary:

• Installation, configuration, and upgrading of Oracle Applications (R12 and 12.2) and Oracle Database (Versions 11i through to 19c)
• Maintain Application security through best practices and security patches.
• Manage various Applications log files and write scripts to automate the process.
• Manage, monitor, configuration of Oracle workflow in conjunction with Functional experts.
• Configuration and maintenance of Java mailers.
• Configuration of live/standby environments using Oracle Data Guard and scripts to switch both database and application between nodes.
• Maintenance and configuration of Oracle applications auditing.
• Backup and recovery using RMAN, hot and cold backups, and application server backups.
• Patch analysis for Oracle E-Business suite including annual legislation patches, security patches (Both application, application tech stack, and database tech stack)
• Design and implement environment cloning strategies, scripts, and schedules.
• Assist with the design of architecture for hardware upgrades.
• Integration of E-Business suite with other environments such as OBIEE and other bespoke systems.

Skills on Resume: 

• Installation, Configuration and Databases (Hard Skills)
• Application Security Management (Hard Skills)
• Log File Management and Scripting (Hard Skills)
• Oracle Workflow Management (Hard Skills)
• Java Mailer Configuration and Maintenance (Hard Skills)
• Oracle Data Guard Configuration (Hard Skills)
• Oracle Applications Auditing (Hard Skills)
• Backup and Recovery Management (Hard Skills)