What are the responsibilities and job description for the DBA position at PGMTEK Inc.?
Job Description
This 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 :
- 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.
Education and Experience Requirements :
