Responsibility as a database administrator (DBA) will be the performance, integrity and security of a database. You'll be involved in the planning and development of the database, as well as in troubleshooting any issues. Also transform the data for various reporting and migration needs.
Responsibilities :
Install and maintain the performance of databases Develop processes for optimizing database security Set and maintain database standards Create and manage database reports, visualizations, and dashboards Create and manage data warehouses for custom reports via third party APIs like Power BI, Holistics, Metabase, Mode Analytics Must guarantee that data is stored securely and optimally Manage database access Performance tuning of database systems Install, upgrade, and manage database applications Use high-speed transaction recovery techniques and backup data Minimize database downtime and manage parameters to provide fast query responses Diagnose and troubleshoot database errors / queries Recommend and implement emerging database technologies Create automation for repeating database tasks
Requirements
Database Administrator Qualifications / Skills :
Strong command of SQL and SQL server tools Advanced knowledge of database security, backup and recovery, and performance monitoring standards Understanding of relational and dimensional data modeling Strong mathematical and statistical knowledge Excellent written and verbal communication skills Impeccable attention to detail
Education and Experience Requirements :
Bachelor's degree in computer science or a related field Three to five years of experience in database administration, information technology, database architecture, or a related field Proven working experience as a Database Administrator Hands-on experience with database standards and end user applications Excellent knowledge of data backup, recovery, security, integrity and SQL Familiarity with database design, documentation and coding Experience with Windows(required) and Linux(optional) Server environments Extensive experience with database technologies (MS SQL required) - (MySQL, PostgreSQL Oracle, MongoDB optional) Experience with cloud services (AWS, Microsoft Azure) a plus
#J-18808-Ljbffr
Database Administrator • Rawalpindi Cantonment, Pakistan