What are the responsibilities and job description for the Microsoft SQL Server DBA must have strong Exp. in AWS, RDS, EC2, PostgreSQL position at Unisoft Technology Inc?
Job Details
Looking for senior SQL server DBA must to have strong in cloud AWS experience.
Title: SQL Server DBA
Location: Maryland (100 % onsite)
Mode of Interivew: In-Person and F2F Interview.
Roles and Responsibilities:
- Provide technical expertise and support in the use of DBMS.
- Evaluate and recommend available DBMS products to support validated user requirements.
- Define file organization, indexing methods, and security procedures for specific user applications.
- Create and maintain database objects such as tables, views, index, constraints, etc. for data platforms and custom applications.
- Develop, implement, and maintain database backup and recovery procedures for the processing environments, and ensure that data integrity, security, and recoverability are built into the DBMS applications.
- Drive end-to-end availability, performance monitoring, and capacity planning for PostgreSQL, using native and 3rd party tools.
- Design and develop logical and physical database designs from application requirements.
- Design and implement automation using scripts and database functions.
- Design and implement replication and backups for mission critical/tier-1 applications.
- Design and implement automation using scripts, must be proficient in scripting.
Education:
- Bachelor's Degree from an accredited college or university with a major in Computer Science, Information Systems, Engineering, Business, or other related scientific or technical discipline.
Experience:
- At Least 12 years of experience in Database
- At least six (6) years of experience in administering on-prem/cloud based multiuser environments with expertise in planning, designing, building, and implementing complex database systems.
- Administrated databases throughout the non-production (Sandbox, development, test, UAT, Training), pre-production (Staging) and production lifecycles in an AWS environment.
- Experienced with optimizing database performance through exhaustive pro-active testing and ongoing real-time monitoring.
- Experienced in scripting and database functions.
- Experience in testing database security and enterprise policy guidelines according to established best practices.
- Monitored and maintained the backups for database recoverability for all production databases.
- Must have experience working in the database domain with at least Eight (8) years of experience managing all operations of RDBMS databases such as Oracle/SQL Server/DB2 with a minimum of two (2) years of EDB PostgreSQL DB.
- Experience with AGILE a plus.
----------------------------------------------------------------------------------------------------------------------------------
Unisoft is an Equal Employment Opportunity (EEO) Employer
All our Information Technology professional positions required a minimum Bachelor degree in computer Science or Information Technology or related field.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
