mysql & mongodb expert
Last active: 1 month ago
-Data Modelling and Database Design
Create database designs by performing needs / requirement analysis, creating a logical mode, and then implementing the physical model.
-Backup and Recovery
Making periodic backups of data and keeping it safe from accidental or intentional destruction. Testing recovery plans so that when problems do arise, data can be restored quickly.
Watch data growth, and plan how best to deal with it. This may include archiving it, increasing the size of current hardware, or adding new hardware.
Server configurations, database schema change over time. Perform impact analysis before changes are made, implement changes, test changes, and document them.
Ensure high availability, including use of log shipping, clustering, database mirroring, and other technologies.
Monitoring performance, monitoring server disk space, monitoring logs, ensuring jobs have run successfully, checking for errors, and so on.
Perform needs/requirements analysis. Talking to users, finding out their needs and requirements, and determining the best way to meet them.
Monitor performance to determine ways to optimize database performance.
Writing reports against databases in transact-SQL code to extract the data, or creation and formatting physical reports.
Control who can access data and what they can do with it. Creating SQL Server login IDs, database IDs, assigning permissions, moving security between servers.
Testing servers, testing databases, testing applications, testing management tools, and so on. Ensure that data integrity and high availability, is maintained at all times.
Sharing knowledge with other DBAs, developers, or end-users.
-Working with colleagues
Interacting with other DBAs, developers, end users, product-knowledge specialists, vendors, accountants, hardware experts, and networking experts.