As simple as this question sounds, it is one of the most complicated questions which will always be the first at every interview. The foundation of your interview is determined by your respond to this question. Most people will think the right response is this – My name is Susan; I live in Virginia. I am married with 2 kids and my parents are deceased. No…No …No. The interviewer is interested in understanding your experience and how it has prepared you for the position with the company. At some point all jobs have a core common ground in the sense that most technologies in the market today are all very similar and about 90% of companies utilize the same techniques and technologies. It is recommended you read through as many job descriptions possible while continually staying informed with recent technologies in the market. Now, you have a little understanding of what is required of you, let me give you a sample response to the about question for an oracle database administrator called John Mark.
Thank you sir/Mme for this question. My name is John Mark and I have 10years experience working as an Oracle database administrator. Over the years, I have worked for diverse industry leaders such as pharmaceutical, Banking and finance, Telecommunication, Health, Automotive and government offices. In my position as an Oracle DBA, I have installed and used 11g, 12C, 18C and 19C software (with multitenant solutions including container and pluggable databases). Database creation with database configuration assistant (DBCA) and manually using scripts using the system development lifecycle (SDLC). User management has also been part of responsibilities in which I granted users access to databases based on the principle of least privilege, reset and unlocked user account, troubleshoot connection issues with different tools from SQL*PLUS, SQL Developer just to name a few. I have also built database applications for transaction processing using oracle data modeller and DBArtizanin which the conceptual, logical and physical data models (entity relationship diagrams – ERD) was built with all entities, attributes, relationships, primary, foreign keys, unique key constraints, index, sequences, synonyms and other database objects were implemented in the third normal form – 3NF. Database security was also a very important task I had to complete on a daily bases using transparent data encryption and oracle wallet. I have also tuned databases to improve execution time of application queries using the TOP to BOTTOM approach in which I used tools like; ping, TOP command, mpstat, iostat, ADDM, AWR, ASH report, explain plan, SQL tuning advisor, SQL access advisor, oracle enterprise manager – OEM, SQL plan monitor, statistics gathering and rebuilding index. Some of my responsibilities included automation of frequent database tasks (like; database backups, gather statistics jobs and other reporting tasks) using crontab, OEM and One automation. I have also written and implemented several backup strategies which included; full database backup, incremental cumulative and incremental differential backups for small, medium and very large databases respectively. Backups were taken using recovery manager – RMAN (for physical backups) and logical backups using DATAPUMP (refreshes). Dataguard implementation for disaster recovery solution, Goldengate for data replication and Real application cluster – RAC are projects I have actively implemented, supported and preprepared knowledge transfer articles for others to use across the organization. 25% of my tasks was attending meetings with clients, documenting business requirement documents, proposing solutions for client issues in a wide array of issues from database to cloud computing solutions, resolving database errors including oracle internal errors in which case I open service requests – SR with my oracle support – MOS. Presenting new ideas to the team on automation and make our jobs easier. In my career, I have also been opportune to mentor juniors DBAs in order to ease their transition into the role. I am a good listener, multitasker, leader and pay attention to details. Reading, working out, hiking and cooking are my hobbies.
Now, you have a good understanding of how to approach this question, it can be customized to work in any field of work. Just focus on highlighting what task and projects you completed including what tools you used to accomplish each task on a high-level summary only. Avoid going into details as that’s the purpose of the interview.