We provide IT Staff Augmentation Services!

Database Administrator 4 Resume

5.00/5 (Submit Your Rating)

Washington, DC

SUMMARY:

  • With over 12 years of database administration in Big Data platforms such as Greenplum, Hawq, mongoDB, Netezza and a Certified SQL Server DBA with extensive experience in MS SQL SERVER 2017/2016/ 2014/2 /2000 .
  • Administration of GreenPlum databases throughout the development and production lifecycles.
  • Supported development resources and Operation on their monthly Greenplum process.
  • As team lead, and with in - depth knowledge of GreenPlum architecture, I provided Greenplum knowledge dumps and training to the team along with other technologies.
  • Worked on the migration from Pivotal HD to HortonWorks and AWS in our Production environment.
  • Experience in Analysis, Design, Development, Testing and Maintenance, Capacity Planning, Performance support of application systems of OLTP and OLAP databases in the client-server, internet\internet environments.
  • Experience in Installing, Upgrading and Migrating databases in and from SQL Server 2014/2012/2008 R2\2008\2005.
  • Expert in RDBMS S/W installation, database server builds, applying patches, applying patches in VM environments (VTM), upgrading, configuring, trouble shooting of SQL SERVER on Windows 2000/03/08/2012 servers and Clustered VMware Environments.
  • Good knowledge on new features Data Compression, Transparent Data Encryption (TDE), Resource Governor, Policy Based Management, Backup Compression and Change data capture in SQL SERVER 2008/2012.
  • Expert in Disaster Recovery plans by configuring Clustering, Log-shipping, Mirroring and Replication (Snapshot and Transactional).
  • Hands on experience in configuring Clustering in Active-Active and Active-Passive nodes.
  • Expertise in automating the system by using System Center Operations Manager (SCOM).
  • Experience in configuring Replication and troubleshooting the issues with transactional replication.
  • Experience in query optimization and performance tuning. Used SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands.
  • Expert in tuning the long running Queries and Store Procedures by examining the execution plans.
  • Hands on configuring Temp DB with considerable Memory and Raid Levels for better performance.
  • Expertise in using Performance Monitor/Profiler /Activity Monitor to resolve Dead Locks, Long Running Queries and Bottlenecks caused by complex Queries.
  • Excellent skills in database Back Up, Restore, Recovery, updating statistics, Rebuilding and Reorganizing indexes, Defrag Tables, Replication, Linked Servers and Database Maintenance Plan.
  • Created Linked Servers between SQL Servers and also to Oracle Databases.
  • Documented Disaster recovery plans and participated in Disaster Recovery Drills by implementing Root Cause Analysis (RCA) for troubleshooting and resolving the issues.
  • Expert in raising the Service Requests and keep tracking of requests.
  • Expert in Detecting and Resolving Locks and Deadlocks using the Trace Flags and Native tools like Profiler and the Activity Monitor.

PROFESSIONAL EXPERIENCE:

Confidential, Washington, DC

Database Administrator 4

  • Administered all aspects of databases. This includes being proficient in scheduling, quality control, reports, coordination, and reporting.
  • Provided monitoring to engineering analysis tools to achieve optimum performance and high availability. Designed and implemented data strategies for high availability.
  • Assisted in database design and implementation.
  • Updated and amended existing databases.
  • Setting up and testing new database and data handling systems.
  • Monitored database efficiency.
  • Sustained the security and integrity of databases.
  • Created complex query definitions that allow data to be extracted.
  • Trained colleagues in how to input and extract data.
  • Provided historical reference by defining procedures for retention, protection, retrieval, transfer, and disposal of data.
  • Maintained efficiency by planning and implementing new systems and techniques.
  • Minimized database downtime and manage parameters to provide fast query responses.
  • Performed tests and evaluations regularly to ensure data security, and integrity.
  • Provided proactive and reactive data management support and training to users.
  • Determined enforced and documented database policies, procedure and standards.
  • Defined users and enabled data distribution to the right user, in appropriate format and in a timely manner.
  • Completed operational requirements by scheduling and assigning employees; following up on work results.
  • Kept management informed by reviewing and analyzing special reports; summarizing information; identifying trends.
  • Maintained professional and technical knowledge by attending educational workshops; reviewing professional publications; establishing personal networks; participating in professional societies.
  • Contributed to team effort by accomplishing related results as needed.
  • Provided the engineering required to ensure a stable, highly available, and optimally tuned Data Science Platform through application and system-level configuration.
  • Troubleshooting performance tuning and capacity planning and management for systems across Decision Engineering

Confidential, Bowie, MD

Lead Senior Greenplum and SQL DBA

  • Provided day to day database administration of Greenplum databases in an Azure/AWS/DCA and Disaster recovery clusters.
  • In charge of providing performance monitoring, and capacity planning for GreenPlum, using different tools such as Command Center, PGAdminIII and Aginity
  • Responsible for requested segment expansions for performance gains and software upgrades on Postgres and Greenplum level to address known bugs.
  • Implemented automated scheduled gpcrondumps in the cron tab for our weekly and daily backups.
  • Initiated monthly data dumps to flat tables on Isilon for migration of data to other clusters with different segment and hardware configuration using gpfdist
  • Provisioned user\server access to the Greenplum clusters by modifying the pg hba.conf file
  • Worked very closely with assigned Pivotal Engineer in resolving know issues in our Greenplum production environment, submitting and escalating tickets to vendor and additional knowledge transfers.
  • Generate reports of all processes and jobs currently running on Greenplum and space availability.
  • Discussed data skew with Development to determine if we are leveraging the right distribution keys in tables.
  • Supporting an exponentially growing database environment with over 2000 SQL Server instances and databases averaging 2-4 Terabytes in production
  • Working with Remedy Tickets (Any changes on staging and development environment need to Create Remedy Tickets)
  • Involved in all ITIL process like Change management, Incident Management & Problem Management.
  • Developed and deployed stored procedures, created triggers and audits.
  • Developed Jobs for maintenance in terms of updating statistics, rebuilding indexes, scheduled full/diff/log backups, refreshing database environments periodically or on demand. Also, set up notifications for failure of jobs etc.
  • Actively participated in determining the database schema, database schema changes, implementation plan for database schema releases in coordination with developers and data modelers in adherence with Organization policies.
  • Proactively monitored, determined and solved issues at SQL/database/server levels.
  • Assisted with backups and restores, development of maintenance type procedures that report on the health of the SQL database systems;
  • Worked closely with Senior DBA to support, maintain and monitor disaster recovery mechanisms that ensure; data integrity, data availability. in the event that a corporate data center was lost; we currently have Bowie “Primary” and Confidential “secondary” Maryland;
  • Ensured that all assign task and routine procedures are followed and completed within the allowed time frame;
  • Ensured that nightly and weekly backups are completed each day on all SQL server instances. A great majority of backups are automated jobs that run on a nightly basis, in these cases the DBA would simply review logs to ensure backups have completed. When new databases are requested, the DBA may be asked to create the database as well as add it to the existing backup schedule for that particular server; troubleshoot and rectify any issues with database backup;
  • Created new maintenance jobs for the following: (Backups, Restores, and data migration task). Before any maintenance plans are implemented in production it must be tested in the production environment first. This goes for objects and code of any kind;
  • Ensured that all SQL instances are running the latest patches and correct versions of supporting tools and add on enhancements. It is not necessary the responsibility of the DBA to repair/update or taken any action their self, but issues such as this should be brought to the attention of the senior level DBA and Infrastructure team;
  • Assisted Senior DBA with the overall management of the entire SQL enterprise, creating users, delete/disable user accounts, ensure performance tuning jobs execute and complete in the scheduled window that they were designed to run within;
  • Performed SQL Server installs, upgrades and configuration;
  • Capacity planning and monitoring database growth;

Confidential, MD

SQL-Oracle DBA/Product Specialist

  • Installed, upgraded and applied patches to Oracle, Microsoft SQL 2000/2005 and Vastech’s application software on client’s database and application servers.
  • Software testing, functional and technical understanding of the software and database.
  • Database performance tunning through partitioning, indexing and related settings.
  • Making daily backups of database for successful restore when needed.
  • Work with the development team and the user community to optimize SQL statements.
  • Assist in the troubleshooting and resolution of database and application issues.
  • Responsible for continuous improvement efforts through performance enhancements.
  • Executes some queries on behalf of the development team.
  • Testing product enhancements and fixes during the product release cycle and on as-needed basis.
  • Using SQL to troubleshoot relational database schemas.
  • Maintaining excellent working relationship with client contacts.
  • Providing telephone, email, and end-user support for troubleshooting client software issues.
  • Providing internal technical support for Vastech’s Implementation team.

Confidential, Lanham, MD

Oracle DBA

  • Installing and upgrading Oracle server and client software applications,
  • Creating databases, providing on the spot troubleshooting for developers in development and test environments.
  • Creating tablespaces, managing storage allocations by adding datafiles to existing tablespaces, creating redo log files in terms of tuning to achieve optimal performance for transactions, etc.
  • Write SQL scripts to perform table, index, synonym, view creations.
  • Ensure daily backups are successful and useable to restore Installing, configuring, and maintaining all database servers, working with network engineers in moving servers behind the firewall, and configuring TNSNAMES.ora files to access databases behind the firewall.

Confidential Columbia, MD

Systems Analyst

  • Provide first level technical support for Confidential point of sales systems.
  • Resolve customer software and hardware related issues using available resources.
  • Answer incoming customer calls in a timely manner and/or takes assignment of cases from others.
  • Support Implementation personnel with technical questions.
  • Escalate unresolved cases as necessary.
  • Dispatch unresolved cases appropriately as needed.
  • Document all work as instructed.
  • Use discretion and judgment to ensure customer satisfaction and utilization of time.
  • Other duties were assigned.

ACTIVITIES/ AWARDS

Frostburg State University Varsity Football Team ( ), Dean’s list ( ).

We'd love your feedback!