Database Administrator

Title: Database Administrator
Location: 2 BROADWAY NEW YORK NY

Job Description

Above average English written & oral communication skills coupled with the ability to effectively collect and interpret data from various verbal and written sources.

Proficiency with Microsoft Windows based operating systems such as Office Excel PowerPoint and other applications.

Proven ability to act in a professional manner and maintain a positive attitude.

Ability to work in a multi-faceted fast-paced and high intensity Security environment while maintaining a calm and professional demeanor.

Previous experience gathering organizing and managing computer data.

Work experience with SQL & PYTHON

RESPONSIBILITIES

DATA GATHERING - The successful applicant shall engage in obtaining and gathering statistic data concerning incidences of fare evasion occurring at various MTA locations as detailed herein. This service includes but is not limited to the dictates of workflow requirements as stated by the cognizant Director Data Information and Analysis.

COMPILING and REVIEWING RECORDS - The successful database administrator / data professional shall utilize current MTA designated computer interfaces and systems as detailed herein to include both internal reports and databases.

DATA ANALYSIS - Under the direction of the cognizant Director Data Information and Analysis the database administrator / data professional Consultant will be responsible for the successful analysis and presentation of data. Data analysis includes the ability to compile crime related data fields enter data assign priorities follow Standard Operations Procedures (SOP) and determine relevancy and utilize SQL PYTHON to turn varied datasets into actionable insights.. Data collection and gathering from various MTA Agencies for daily security operational statistics. Development of action plans schedules and keeping meeting participants currently appraised.

Connect and integrate data from various sources such as databases spreadsheets relational databases and cloud services into synchronized datasets.

Clean and organize data to ensure it is suitable for reporting and analysis.

Develop and maintain reports and dashboards which provide data insight and support management decision-making.

Identify areas of system optimization based on business processes.

Follow security measures to ensure data confidentiality and compliance with data protection regulations.

Collaborate with business analysts data engineers and other stakeholders to understand requirements and deliver solutions that meet business needs.

Create maintain and manage documentation for data models report specifications and adherence to best practices.

QUALIFICATIONS EXPERIENCE & EDUCATION

Bachelors degree in information systems Computer Science Business Administration or a similarly related field.

Solid and progressive experience in working with relational databases.

Excellent analytical skills with the ability to dissect large amounts of data.

Strong communication skills and the ability to effectively convey complex information.

Experience in the transportation especially in railroad industry is a plus.

4 years of experience in Reporting and Dashboards.

4 years in database technologies and strong writing skills.

Microsoft Power BI Data Analyst certified preferred.

Good communication skills to translate business requirements into Dashboards and Reporting

Proficient in MS Office applications Word Excel Visio PowerPoint Project

Excellent oral written and presentation communication skill in successfully relating technical information to non-technical personnel.

Strong analytical and problem-solving skills

Ability to effectively prioritize and execute in a high-pressure environment.

Ability to independently set priorities and meet deadlines.

Excellent inter-personal skills including the ability to work with individuals at all levels of the organization.

Required Skills:

1. 5 years Handson experience with Cloudflare WAF (policies rulesets firewall rules bot management DNS DDoS logpush). 2. 4 Handson experience with Akamai WAF (KSD/Property Manager Bot Manager Edge DNS log staging/testing). 3. Deep understanding of OWASP Top 10 application security principles secure development practices. 4. 5 Experience with SAST/DAST/SCA tools such as Checkmarx BurpSuite Fortify or equivalents. 5. Experience analyzing traffic headers payloads and attack vectors (XSS SQLi RCE deserialization CSRF SSRF etc.). 6. Experience with cloud platforms (Azure AWS SaaS) and modern application architectures.

Required Education:

Preferred masters or bachelors in computer science or a related field.