Database Analyst / Administration Resume Samples
Who is Database Administrator
A database administrator (DBA) is responsible for the maintenance, performance, security, and reliability of a databases. A database administrator works with various types of databases, such as relational databases, NoSQL databases, and cloud-based databases. DBA oversee routine operations of the database, while ensuring data availability and integrity. DBAs are also involved in the design and development of new databases, as well as tuning existing databases to improve performance.
The specific responsibilities of a database administrator can vary depending on the size and complexity of the organization, as well as the type of databases. Some of the common tasks of DBA include:
Installing and upgrading databases and related software
Configuring and maintaining database security
Monitoring and optimizing database performance
Backing up and recovering data
Planning and managing the storage and archiving of data
Ensuring data consistency and integrity by implementing and enforcing standards and policies
Troubleshooting and resolving database-related issues
Training and supporting end-users and developers
Staying current with new developments and trends in database technology
Technical Skills of Database Administrator
Database administrators are highly skilled professionals and technical skills required for a database administrator typically include:
Knowledge of database management systems, such as Oracle, MySQL, Microsoft SQL Server, etc.
Proficiency in SQL and database programming languages
Experience with database design, backup and recovery, and performance tuning
Familiarity with operating systems, such as Windows or Linux
Understanding of network infrastructure and security
Knowledge of data warehousing, data modeling and data governance
Knowledge of cloud-based database solutions such as Amazon RDS, Azure SQL Database, etc
Ability to troubleshoot complex database issues and resolve them in a timely manner
Understanding of data migration, replication and backup and recovery methods
Good interpersonal and communication skills to work with other team members and stakeholders
Analytical, enthusiastic, and self-motivated professional with hands-on experience executing several facets of database design, development, deployment, and administration. Possess in-depth knowledge and working understanding of data Modeling whilst identifying, recommending, and implementing emerging Modeling and database trends, developments, tools, and improvements/solutions. Proven success in creating, documenting, and maintaining logical and physical database models in compliance with set organisational standards. Excel in development of databases by analysing/designing new and existing processes and schema design. Adept at recognising potentially complex problems whilst handling and resolving core issues promptly under high-pressure situations. Expert at maintaining professional attitude and attention to detail while working alone and within a team environment. Demonstrated history of excellence in supporting staff effectively at all levels.
Results-driven professional with hands-on experience executing various facets of database design, development, deployment, and management with unequalled success. Excel at retrieving data from documents and databases with high attention to detail, ensuring absolute accuracy. Adept at developing long-term strategy for data/records improvement by gathering and evaluating database needs. Expert in development of databases by analyzing/designing new and existing processes, upgrades, and data migration. Skilled at developing and enhancing professional relationships with all stakeholders.
Highly motivated and result-oriented professional with proven ability of developing, presenting, and maintaining intuitive/interactive database solutions and reports by utilizing available tools and technologies. Adept at collaborating cross-functionally with team members to ensure attainment of collective goals/vision. Possess in-depth knowledge and understanding of database systems and data analysis software tools, including Raisers Edge Database and Raisers Edge NXT systems. Technical minded; excel at identifying emerging technologies that fully leverage the capabilities of existing databases. Thrives in competitive and challenging markets and adapts to the ever-changing demands of IT field. Strategist with the business savvy to improve operating efficiencies through technical improvements. Skilled in mastering and learning new skills, techniques, and technologies.
Day-to-day Job Duties of DBA
Perform end-to-end activities requested from president, mitigation coordinator, and construction project manager.
Record all information in databases whilst verifying grammatical and numerical accuracy.
Gather, review, and update customer, vendor, and sub-contractor information based on verbal communication, internet research, and scanned documents.
Conduct and manage transition of 600+ contacts into new database management.
Perform numerous functions involved in accounts receivable and collection activities.
Monitor and manage Oracle databases such as 12C/18C on AIX, LINUX, and Solaris platform across RAC architecture consisting of multitenancy components (CDB-PDB) and ASM infrastructure.
Engage in activities related to monitoring and evaluation of database’s health, while performing preventive actions as required by utilizing Oracle tools, such as AWR and Oracle enterprise manager cloud control 13C.
Conduct routine checks of operational data via Corelogic Mosaic infrastructure to resolve issues related to database tablespace dimensions, password management, and software installation.
Perform routine activities related to Oracle nd MySQL database administration at Italian postal service.
Execute several facets involved in efficient management of high-volume issues and incidents in large and complex database environment by leveraging BMC remedy.
Oversee management and profiling of various databases access.
Achievement or Accomplishments
Ensured efficient management of high volume of issues and incidents in challenging banking environment, meeting demanding Service-level Agreements (SLAs).
Administered database’s storage structures, including management of users, security, and schema objects, such as tables, indexes, and views, as well as database backups.
Identified and resolved issues in line with defined SLAs load prioritisation through collaboration with system administrators and application owners, while meeting and exceeding deadlines, as well as supporting key stakeholders both internally and externally.
Served as database administrator on Clog data warehouse that contained all logs of INPS applications.
Trained Oracle Certified Professional Courses (OCA/OCP) at large training centre and achieved high levels of exam passing rate and over 90% customer satisfaction on client surveys.
Identified and resolved issues in line with demanding Service-level Agreements (SLAs) by collaborating with systems administrations, application owners, and programmers.
Performed assessment and execution of new functions related to dashboard written with APEX (Oracle 10 G Express Edition) on platform Microsoft Windows server standard edition.