- Perform database installation, upgrade, migration, configuration, administration, and security patches.
- Design and implement database structures on relational schemas and tables. Perform other database housekeeping activities such as security administration, user access management, backup/recovery, and performance monitoring.
- Execute routine database backup and disasters recovery activities.
- Perform service packs and security patches updates at the OS and MS SQL Server levels, as well as other database-related vulnerabilities remediation to comply with the Branch policies and standards.
- Monitor, troubleshoot databases issues, and conduct performance tuning, including but not limited to slow queries, statistics, indexing, partition, etc.
- Deploy new code release in lower and production environments.
- Conduct database maintenance, performance tuning, capacity planning, database optimization, and other database administration tasks.
- Implement SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
- Diagnose and troubleshoot ETL process and database errors.
- Develop processes and build standards for Data Replication, Database Security, Encryption, Compression and Data Masking/Redaction.
- Manage and administer database access and database user access management, set and maintain database standards.
- Maintain version control on system servers and other application servers.
- Report on KRI & KPI metrics regarding usage and performance.
- Create and manage database reports, visualizations, and dashboards.
- Create automation for repeating database tasks.
- Respond in a timely manner to user-reported errors.
- Suggest changes and improvements for database maintenance or protection.
- Design databases with both front-end and back-end users in mind.
- Strong organizational skills with attention to detail and the ability to manage multiple and concurrent tasks.
- Excellent communication and documentation skills.
- Any other work assigned by IT Department Management.
- A bachelor's degree in computer science or a related field.
- A minimum of 3 years' experience as a database administrator.
- Oracle and MS certified Database Administrator is prefered.
- Proficiency in data manipulation languages, including MS SQL Server, Oracle database, Hadoop, or PostgreSQL.
- Excellent experience with RDBMS, especially in Database tuning, upgrades, installation, configuration, security patches, and etc.
- Advanced knowledge of database security, backup and recovery, and performance monitoring standards.
- Strong experience with performance tuning, capacity planning, and optimization of database environments.
- Performance of load balancing/High Availability (HA) and Disaster Recovery (DR) options for SQL Server.Advanced knowledge of Microsoft Business Intelligence Technology including T-SQL, SSIS, and SSRS.
- Understanding of relational and dimensional data modeling.
- Good understanding of VMWare environment, the storage hardware and software.
- Experience working with Windows server operation system, including Active Directory.Good to have experience writing PowerShell, and/or Python.
- Analytical mindset and good problem-solving skills.
- Capable of working under pressure.
- Ability to read, write and speak Mandarin a plus.
-
Dba/ BI Developer
6 days ago
IT Customer Service - POST New York, United States Part time**Job title: DBA/ BI Developer** · **Location: New York/New Jersey(Remote)** · **Key Responsibilities**: · - Perform business and data analysis to understand requirements and translate them into effective BI solutions. · - Develop and optimize T-SQL queries for data extraction, t ...
-
Oak View Group New York, United StatesOak View Group: · Oak View Group is the global leader in venue development, management, and premium hospitality services for the live event industry. Offering an unmatched, 360-degree solution set for a collection of world-class owned venues and a client roster that includes the ...
-
Oak View Group New York, United StatesOak View Group: · Oak View Group is the global leader in venue development, management, and premium hospitality services for the live event industry. Offering an unmatched, 360-degree solution set for a collection of world-class owned venues and a client roster that includes the ...
-
Principal DBA
5 days ago
Index Exchange New York, United StatesWe shaped the earliest forms of ad tech, and we're looking for the technical expertise to help shape its future. Our customers have unique problems that can only be solved at internet scale, and that's where the technical skills of our team make a real difference. · Our exchange ...
-
Oak View Group New York, United StatesOak View Group: · Oak View Group is the global leader in venue development, management, and premium hospitality services for the live event industry. Offering an unmatched, 360-degree solution set for a collection of world-class owned venues and a client roster that includes the ...
-
sql dba
6 days ago
Saxon Global New York, United StatesPosition: Sr. SQL DBA · Location: Fort Lauderdale, FL · Duration: 6 Months Contract to hire · Hybrid Position · Jod Description: · Here is the JD for a role we have with AutoNation. This role is hybrid in Fort Lauderdale, so the candidate must be local or be willing to relo ...
-
Oracle DBA
2 days ago
The Dignify Solutions LLC New York, United StatesMinimum 10+ Years of experience in Database Administration. · Experience with AWS architecture. · Experience in designing and supporting Database as a Service (DBaaS) platform . · Understand end-to-end configuration, technical dependencies, and overall behavioral characteristics ...
-
Oracle DBA
6 days ago
Atechstar New York, United States Full time, Part time, contract, trainingJOB DESCRIPTION Your Role and ResponsibilitiesAdminister maintain tune and troubleshoot Oracle databases to provide high availability and reliability to the databases and applications running on them. Administer databases running on RAC in Exadata environments. Work with applicat ...
-
Oracle DBA
4 days ago
The Dignify Solutions LLC New York, United StatesThe Adobe AEM DAM Developer codes software applications based on business requirements. · The Adobe AEM DAM Developer work assignments are varied and frequently require interpretation and independent determination of the appropriate courses of action. · The Adobe AEM DAM Develope ...
-
Cloud DBA
2 weeks ago
Trinity IT Services Jersey City, United StatesJersey City, NJ · 3 days on site- Hybrid Role · GC or USC · *** MUST Have Investment Banking and Market Data environment experience*** · Database team is currently looking for a Database Engineer with experience doing DevOps to join our offshore team · Cloud Database RDS · ...
-
Oracle DBA with GIS
1 week ago
DONNELLY & MOORE New York, United StatesOur Utility Client in NYC is looking for an Oracle DBA with GIS experience for a 12+months project. This is contract role will need the consultant to have an onsite presence so locals are preferred. · Assignment Details · Support OMS and GIS Environment & Databases · o OMS and E ...
-
Oracle DBA with Exadata
2 weeks ago
Aptino Inc New York, United StatesRole: · Oracle DBA with Exadata · Location: · California ( Hybrid - 3 days per week Onsite) · Duration: · 10 month · Job Description: · We are seeking a skilled Oracle Database Administrator (DBA) with extensive experience in managing Exadata environments to join our team. Th ...
-
Oracle GoldenGate DBA
2 weeks ago
Con Edison New York, United StatesOracle GoldenGate DBA - IT Integration Services · Job Info · 111429 · Posting Expiration Date:Apr 30, 2024 · Schedule Type:Full-Time · Minimum Salary:$95000 · Maximum Salary:$125000 · Organization:IT Engineering & Operations · Department:Architecture/Digital Platforms · Section:I ...
-
PeopleSoft Oracle DBA
3 days ago
Priority Groups New York, United StatesJob Description · Job DescriptionOverview: · ESO Consultants is currently seeking a skilled individual for the position of PeopleSoft Oracle DBA. The role involves analyzing data requirements, defining database architecture, testing databases, and maintaining Oracle Databases acr ...
-
db2 dba
2 weeks ago
Saxon Global Jersey City, United StatesJob Description · Exactly what are they doing for the project (Day to Day)? · Performance Tuning · Informatica /Snowflake · DB2 Linux 11.0 moving to 12 · Shell scripting · LUW or z/os · Data Replication · Must Haves: DB2 Linux (Version 11 moving to 12) · Informatica OR Sn ...
-
Senior Oracle DBA
5 days ago
Comprehensive Resources New York, United StatesROLE: Senior Oracle DBA - OMS/GIS · VISA: No CPT,OPT · LOCATION: Hybrid in NYC · Experience : 11+ · Need Local or Nearby States · JOB DESCRIPTION · Support Oracle OMS and eSRI based GIS Environment & Databases · OMS and GIS related Linux /Windows server requests built to ConEd s ...
-
Senior Oracle DBA
5 days ago
Seneca New York, United StatesA leading utility provider located in New York, NY is looking for a Senior Oracle DBA (OMS/GIS) for a 12+ month contract. · This is a hybrid role in New York City. · Pay Rate Range: $ $75.00 · Required Skills & Experience: · Experience managing Geographic Information Systems ...
-
Senior Oracle DBA
6 days ago
Crossfire Consulting New York, United StatesMust Have: · 3+ years of experience with creating stored procedures in SQL · advanced SQL development in Oracle SQL Developer · Backend Database · optimal oracle database design · Senior Database Administrator · Nice to Have: ArcGIS · ArcGIS Server, Portal · Oracle Utilities · JO ...
-
Sr. DBA
1 week ago
Royal Bank of Canada Jersey City, United States Full timeJob Summary · Job Description · What is the Opportunity? · Global Database Systems is hiring a Sr. DBA (Mongo DB / PostgreSQL) will be responsible for the day-to- day support, projects, changes and problem management. Ensures completeness and integrity of Projects, changes and P ...
-
Senior Oracle Apps DBA
5 days ago
INSPYR Solutions New York, United StatesTitle: · Senior Oracle DBA · Location: · Houston, TX ONSITE) · Duration: · Direct Hire Role · Work Requirements: · US Citizen, GC Holders or Authorized to Work in the U.S. · Job Description: · Minimum 10 years of hands on experience in Oracle DBA skills and 5 years of Oracle ...
dba - New York, United States - PGMTEK Inc.
Description
Job DescriptionThis is a long term consulting role for an international bank in NYC. It is responsible for managing and administering the Branch's databases including but not limited to SQL Server and Oracle, to make sure that data is available to users, and to ensure the databases are secure from unauthorized access or accidental loss or corruption. The position is also responsible for designing, testing, planning, implementing, protecting, operating, managing and maintaining databases applications of the Branch.
Responsibilities:
